Re: pg_restore usage

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".