pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sabin Coanda <sabin.coanda@deuromedia.ro>
To: pgsql-admin@postgresql.org
Subject: WAL based backup/recovery clarifications
Date: Mon, 19 Mar 2007 09:58:34 +0200
Message-ID: <etlfr2$2pa5$1@news.hub.org> (raw)

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 





view thread (2+ messages)  latest in thread

Message-ID: <etlfr2$2pa5$1@news.hub.org>
Permalink:  ../etlfr2$2pa5$1@news.hub.org/
Also on:    postgresql.org/message-id/etlfr2$2pa5$1@news.hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: sabin.coanda@deuromedia.ro
  Subject: Re: WAL based backup/recovery clarifications
  In-Reply-To: <etlfr2$2pa5$1@news.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox