Re: PITR / what directories/files can be ignored? - Mailing list pgsql-general

From Tom Lane
Subject Re: PITR / what directories/files can be ignored?
Date
Msg-id 29020.1166137051@sss.pgh.pa.us
Whole thread Raw
In response to PITR / what directories/files can be ignored?  (Glen Parker <glenebob@nwlink.com>)
List pgsql-general
Glen Parker <glenebob@nwlink.com> writes:
> I am continuing to refine my PITR backup script, and there are some
> directories I do not know what to do with.  First off, here are the
> directories/files I am currently ignoring...

> pg_xlog  (ours is a symlink, so I ignore it altogether)
> pg_log/*
> base/*/pgsql_tmp/*
> postmaster.opts
> postmaster.pid

All OK.

> Can I also ignore any of these? ...

> pg_clog/*
> pg_multixact/*
> pg_subtrans/*
> pg_twophase/*

No!

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: could not write to log -> PANIC -> System down
Next
From: Glen Parker
Date:
Subject: Re: Temp file space (Re: creating an index with tablespace