[pgpool-general: 3966] Re: Archive Cleanup
ishii at postgresql.org
Fri Aug 14 10:03:11 JST 2015
> Hi guys.
> 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?
Yes. What pgpool-II does while re-syncing is quite same as the normal
procedure to create new standby node. So once base backup is safely
taken, keeping older archive files is not necessary.
SRA OSS, Inc. Japan
> 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
More information about the pgpool-general