[pgpool-general: 3963] Re: Archive Cleanup

[Darryl Wisneski]

gzip in the archive_command helps with disk usage.

A daily basebackup out of cron would enable you to nuke WALs older than the most recent basebackup’s 'backup history file.'

Adjust your WAL and basebackup archive retention based on business requirements.

-dkw

From: <pgpool-general-bounces at pgpool.net<mailto:pgpool-general-bounces at pgpool.net>> on behalf of Jonathan Eastgate <jonathan.eastgate at simpro.co<mailto:jonathan.eastgate at simpro.co>>
Date: Wednesday, August 12, 2015 at 10:44 PM
To: pgpool-general <pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>>
Subject: [pgpool-general: 3958] Archive Cleanup

Hi everyone.

We have a successful PGPoolII installation running nicely using streaming replication.

However we're trying to work out what we need to keep in our WAL archives - as these are filling up quickly.

Do we need to run a manual base_backup regularly and clean up anything prior to that in the Wal archive folder? Or based on the fact that PGPool runs a base_backup during a resync when required - that in fact we don't need any of the wal archives?

Would be interested to know how people are handling this?

Thanks

Jonathan

--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150813/d8a57ac9/attachment.html>