From: | "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | restoring from dump |
Date: | 2008-08-22 21:57:56 |
Message-ID: | FE44E0D7EAD2ED4BB2165071DB8E328C0378F40C@egcrc-ex01.egcrc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Everybody,
I had a machine crash a couple of days ago, from which
I have recovered (ie., postgres is running now), but I
want to restore from a dump I had made. The dump is
made by pg_dumpall and I have a gzipped file.
I am a bit unclear as to how to proceed.
(A) I get rid of what I have now and use createdb to
make a "new" database and use psql.
(B) Don't bother with createdb and let the tables be
overwritten.
Also the manual tells me (in section 24.1.2):
psql -f infile postgres
The last parameter: "postgres" is this the database
super-user? If so, do I need to spell it out if I am
logged in as user postgres? If not, what is this?
Please advise. I would appreciate it.
Thank you.
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Frost | 2008-08-22 22:18:38 | Re: restoring from dump |
Previous Message | c k | 2008-08-22 18:08:13 | Re: Auto recovery feature |