Re: restoring from dump

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: restoring from dump
Дата
Msg-id Pine.LNX.4.64.0808221515340.14879@discord.home.frostconsultingllc.com
обсуждение исходный текст
Ответ на restoring from dump  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
Список pgsql-admin
On Fri, 22 Aug 2008, Tena Sakai wrote:

> 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?

Tena,

If you have a gzipped dumpall file, then you would restore it like so:

zcat dumpall.gz | psql postgres

I generally redirect the stdout and stderr output to files for later review
like this:

zcat dumpall.gz | psql postgres > /tmp/restore.out 2> /tmp/restore.err


In this case 'postgres' is the initial database that you're connecting to with
psql.  This is sometimes called the maintenance database. The dumpall file
will contain all the create database commands necessary for restoring every
database that was dumped.

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 916-647-6411    FAX: 916-405-4032

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Tena Sakai"
Дата:
Сообщение: restoring from dump
Следующее
От: "Tena Sakai"
Дата:
Сообщение: Re: restoring from dump