| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | tfo(at)alumni(dot)brown(dot)edu (Thomas F(dot) O'Connell) |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_restore usage |
| Date: | 2004-06-27 14:22:28 |
| Message-ID: | 11767.1088346148@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
tfo(at)alumni(dot)brown(dot)edu (Thomas F. O'Connell) writes:
> I transfer this file to another server, where the database db does not
> exist. I try the following:
> pg_restore -C -d db pg_dump20040621.pgsql
> pg_restore: [archiver (db)] connection to database "db" failed: FATAL:
> database "db" does not exist
> What is an example of how the -C flag is intended to be used?
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".
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Reina | 2004-06-27 17:13:54 | Password with libpq |
| Previous Message | Sanjay Arora | 2004-06-27 01:26:28 | Best approach to database design, in this case? |