Skip site navigation (1) Skip section navigation (2)

Re: WAL based backup/recovery clarifications

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Sabin Coanda <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL based backup/recovery clarifications
Date: 2007-03-21 00:01:33
Message-ID: 200703210001.l2L01XD12793@momjian.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-admin
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(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

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

In response to

pgsql-admin by date

Next:From: David BearDate: 2007-03-21 00:50:21
Subject: which distro, or to build
Previous:From: Claus GuttesenDate: 2007-03-20 20:06:25
Subject: Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group