So these two statements seem to be somewhat contradictory.
What's the point of -C if not to create the database named in -d?
And why does -C -d template1 work but not -C -d ?
-tfo
[EMAIL PROTECTED] (Tom Lane) wrote in message news:<[EMAIL PROTECTED]>...
> Whatever database you name in -d has to
>[EMAIL PROTECTED] (Thomas F. O'Connell) writes:
>> I transfer this file to another server, where the database db does not
>> exist. I try the following:
>
>> pg_restore -C -d db pg_dump20040621.pgsql
>> pg_restore: [archiver (db)] connection to database "db" failed: FATAL:
>> database "db" does n
[EMAIL PROTECTED] (Thomas F. O'Connell) writes:
> I transfer this file to another server, where the database db does not
> exist. I try the following:
> pg_restore -C -d db pg_dump20040621.pgsql
> pg_restore: [archiver (db)] connection to database "db" failed: FATAL:
> database "db" does not exis
