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

From Glen Parker
Subject PITR / what directories/files can be ignored?
Date
Msg-id 4581CBB5.4090704@nwlink.com
Whole thread Raw
Responses Re: PITR / what directories/files can be ignored?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem)
Next
From: "Brandon Aiken"
Date:
Subject: Re: could not write to log -> PANIC -> System down