Re: What directories to include in base backup

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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>