BUG #6008: Can't contact Tom Lane :)
The following bug has been logged online:
Bug reference: 6008
Logged by: gab
Email address: korsani@free.fr
PostgreSQL version: 8.4.8
Operating system: FreeBSD
Description: Can't contact Tom Lane :)
Details:
I opened a bug (#6007), that was handled by Tom Lane. He wrote me a mail,
but when I answer the mail come back to me ("Returned to sender")
I write here my response :
------------->8--------------
Hi,
Here : http://www.postgresql.org/docs/8.4/static/app-pgrestore.html
You can read :
-C
--create
Create the database before restoring into it. (When this option is used,
the database named with -d is used only to issue the initial CREATE DATABASE
command. All data is restored into the database name that appears in the
archive.)
-d dbname
--dbname=dbname
Connect to database dbname and restore directly into the database.
Although "All data is restored into the database name that appears in the
archive" is unclear, as when dumping with "pg_dump -F c" the dump does not
contain the database name ...
----- "Tom Lane" <tgl@sss.pgh.pa.us> a écrit :
Show quoted text
"gab" <korsani@free.fr> writes:
Try to restore it using :
pg_restore -C -d test /tmp/plop
pg_restore: [archiver (db)] connection to database "test" failed:FATAL:
database "test" does not exist
But the doc says that -C use the parameter of -d to CREATE the
database ...
Well, if the docs say that they shouldn't. When you use -C, the
database named by -d is just the one where pg_restore initially
connects
to issue the CREATE DATABASE command. Please specify where you think
the documentation is telling you something else.regards, tom lane
"gab" <korsani@free.fr> writes:
Although "All data is restored into the database name that appears in the
archive" is unclear, as when dumping with "pg_dump -F c" the dump does not
contain the database name ...
Don't know where you got that idea from ... "pg_restore -l" prints the
source database name in two different places for me.
regards, tom lane