I cant seem to get pg_restore to work for me.

here's how im calling it:

pg_restore -d <dbname> -C -v -U <user> <src tar file>

It keeps on telling me that the database <dbname> does not exist so it
cant connect to it. I thought the -C flag creates the database, what am
i missing here?

Thanks

Alex


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Alexander Cohen <alex@toomuchspace.com> writes:[color=blue]
> pg_restore -d <dbname> -C -v -U <user> <src tar file>[/color]
[color=blue]
> It keeps on telling me that the database <dbname> does not exist so it
> cant connect to it. I thought the -C flag creates the database, what am
> i missing here?[/color]

It does, but you have to connect somewhere first so you can issue the
CREATE DATABASE command. I think the common approach is to use "-d template1"
in combination with -C.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)