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
tgl@sss.pgh.pa.us (Tom Lane) wrote in message news:<11767.1088346148@sss.pgh.pa.us>...
> 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".