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