From: | tfo(at)alumni(dot)brown(dot)edu (Thomas F(dot) O'Connell) |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_restore usage |
Date: | 2004-06-21 21:57:17 |
Message-ID: | 80c38bb1.0406211357.f9fadd6@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
A while back, there was a thread on this list called "pg_restore
problem with 7.3.1". It outlined a scenario very similar to one I'm
having problems with. Granted, they're not serious problems (in the
sense that there's an acceptable workaround), but they suggest that
either pg_restore is not working as expected, or I have incorrect
expectations. I'd like to get some clarification as to which is the
case.
I dump a database as follows:
pg_dump -F c db >pg_dump`date +\%Y\%m\%d`.pgsql
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
I get this error:
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? If it is
omitted, then the error is the same because no createdb has been
issued.
In the end, what I'm looking for is a nice way of taking a dump and
restoring it in one command that could be added to a crontab. I
realize that it's not too much extra work to create a shell script
that creates the relevant database, but this seems like such a natural
one-liner, and I'm curious what the intent of the -C flag is, if not
to precipitate such a situation.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-06-22 01:05:29 | Re: UNDO |
Previous Message | Lee Wu | 2004-06-21 18:55:28 | Re: bad data with Foreign Key constraint |