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 :
> "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