[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] pg_restore usage
From:       tfo () alumni ! brown ! edu (Thomas F !  O'Connell)
Date:       2004-06-28 19:55:05
Message-ID: 80c38bb1.0406281155.470ef80b () posting ! google ! com
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html
[prev in list] [next in list] [prev in thread] [next in thread]