[pgpool-general: 3965] Re: Archive Cleanup
jonathan.eastgate at simpro.co
Fri Aug 14 09:51:58 JST 2015
Thanks for those replies.
Not quite what I'm questioning though so let me try and explain better.
When the server is acting as a primary - running streaming replication to a
standby - does PGpool require any of the older files in the Wal archive
directory prior to the execution of the basebackup.sh script during a
resync of the standby?
I ask this because during resync of a standby it appears the Master does
calls for base_backup - which would indicate the the slave node won't
require any Wal archives prior to that point?
Hope that makes it a little clearer?
*Jonathan J. Eastgate*
Chief Technology Officer | simPRO Software Group
Ph: 1300 139 467 +61 7 3147 8777
Keep up to date with simPRO at: simpro.co/blog
The contents of this email are subject to our email disclaimer
On Fri, Aug 14, 2015 at 2:03 AM, Darryl Wisneski <
darryl.wisneski at finalsite.com> wrote:
> 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
> From: <pgpool-general-bounces at pgpool.net> on behalf of Jonathan Eastgate <
> jonathan.eastgate at simpro.co>
> Date: Wednesday, August 12, 2015 at 10:44 PM
> To: pgpool-general <pgpool-general at pgpool.net>
> Subject: [pgpool-general: 3958] Archive Cleanup
> Hi everyone.
> We have a successful PGPoolII installation running nicely using streaming
> 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?
> pgpool-general mailing list
> pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general