problem with pg_restore
Started by Alexander Cohenover 21 years ago2 messagesgeneral
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
Re: problem with pg_restore
Alexander Cohen <alex@toomuchspace.com> writes:
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?
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