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 <mypgsql>?
-tfo
[EMAIL PROTECTED] (Tom Lane) wrote in message news:<[EMAIL PROTECTED]>...
> Whatever database you name in -d has to already exist, because that's
> where pg_restore will initially connect. -C means to issue a CREATE
> DATABASE command and then reconnect to the new db.
>
> In other words, try "-C -d template1".
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
