Postgres Pro
Downloads
Home   >   mailing lists

Re: What directories to include in base backup - Mailing list pgsql-admin

From Selva manickaraja
Subject Re: What directories to include in base backup
Date
Msg-id AANLkTik5vat-waRgAwOdbP9h6UddsHJ_eHCZEqoiDBD=@mail.gmail.com
Whole thread Raw
In response to What directories to include in base backup  (A B <gentosaker@gmail.com>)
List pgsql-admin
Tree view
You can ignore contents of pg_xlog is you are running WAL archiving. You can skip postmaster.pid and pg_log but make sure that you recreate pg_log  in the target.

On Fri, Apr 1, 2011 at 3:13 PM, A B <gentosaker@gmail.com> wrote:
Hello.

I just wanted to check with you, the experts, on what directories to
include in the basebackup (following
http://www.postgresql.org/docs/8.4/static/continuous-archiving.html)

I should include these:

base/
global/
pg_clog/
pg_multixact/
pg_stat_tmp/
pg_subtrans/
pg_tblspc/
pg_twophase/
PG_VERSION
pg_xlog/
postmaster.opts


and I can skip

pg_log/
postmaster.pid

Right?

What about pg_xlog/ directory? Is that really needed? I store the WAL
file in another place already, or should pg_xlog be included just in
case it will be more recent if crash-recovery i possible?

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: A B
Date:
Subject: What directories to include in base backup
Next
From: Anal Dey
Date:
Subject: Restore Backup from Linux to Windows 2003