On 15/06/17 20:48, Peter Eisentraut wrote:
On 6/15/17 00:00, Charles wrote:
Please consider changing "Connect to database dbname and restore
directly into the database" to "Connect to database dbname and restore
directly into the database named in the input file"
But that's not what it does.
Thank you Peter
I am new to postgres so can easily be wrong.
The suggestion was based on how pg_restore behaved when used this way
(as user postgres on a Debian Jessie server):
$ dropdb redmine_default
$ pg_restore --create --dbname=postgres
redmine_default-2017-06-11@18\:21\:06.sql
The .sql file had been created on another server using:
pg_dump --format=custom --lock-wait-timeout=6000000 --username=postgres
--no-password redmine_default
After running the pg_restore command the redmine_default was populated.
Given that database redmine_default was not named on the pg_restore
command I concluded that its name must have been found in the .sql file.
Best, Charles
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
