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
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.
pgsql-admin by date
|Next:||From: Jeff Frost||Date: 2008-08-22 22:18:38|
|Subject: Re: restoring from dump|
|Previous:||From: c k||Date: 2008-08-22 18:08:13|
|Subject: Re: Auto recovery feature|