Обсуждение: WAL based backup/recovery clarifications

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

Sabin Coanda wrote:
> 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 ?

No, you need a binary backup, not a logical backup.

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

All under "data".  Isn't the documentation clear?

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +