[pgpool-general: 3963] Re: Archive Cleanup

Darryl Wisneski darryl.wisneski at finalsite.com
Fri Aug 14 01:03:17 JST 2015

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.


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?



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

More information about the pgpool-general mailing list