On 2/3/2014 4:59 AM, Rajni Baliyan wrote:
> Is there any way to automate the archive deletion process. Any script
> or command in HA setup using pgpool
please don't reply to an existing thread with a completely different
topic and subject matter. your message is threaded under messages
about foreign data wrappers and cost estimation.
WAL archiving and pgpool have nothing to do with each other.
postgres manages the pg_xlog deletion process itself. if you're
keeping an external WAL archive, then any such deletion depends entirely
on your requirements for the use of said archive. if you want to be
able to do 'point in time recovery' aka PITR, you need ALL WAL archives
since the last base backup. if the WAL archive is for streaming
replication to use to catch up after a service interruption, then
probably a day or two is all you need unless you envision longer
downtimes for the slave.
scripts for doing things like deleting old files are OS dependent. on a
(l)unix type system, its as simple as...
find /path/to/files -mtime +2 | xargs rm
will delete everything over 2 days old in that path.
--
john r pierce 37N 122W
somewhere on the middle of the left coast