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(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote in message news:<11767(dot)1088346148(at)sss(dot)pgh(dot)pa(dot)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".