WAL based backup/recovery clarifications - Mailing list pgsql-admin

From Sabin Coanda
Subject WAL based backup/recovery clarifications
Date
Msg-id etlfr2$2pa5$1@news.hub.org
Whole thread Raw
Responses Re: WAL based backup/recovery clarifications  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Hi there,

I'd like to use WAL, but I need some clarifications about the
backup/recovery procedure.

In Postgresql v8.2.3 documentation, I found I have to make backup between
pg_start_backup/pg_stop_backup executions, using tar/cpio tools.

May I use pg_dumpall instead ? Is it enough to restore the database later
with WAL ?

If I cannot use pg_dumpall, please tell me exactly what are the directories
that have to be archived. I note that I use a standard configuration on
Windows.

TIA,
Sabin



pgsql-admin by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: Re: [SQL] create view with check option
Next
From: "Anton Pikhteryev"
Date:
Subject: Re: Problem migrating from 8.0.3 to 8.2.3