Thread: PITR / what directories/files can be ignored?

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


Can I also ignore any of these? ...

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


BTW, PITR is pretty much the best thing since sliced bread :D

TIA,

-Glen

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