[pgpool-general: 3966] Re: Archive Cleanup

[Tatsuo Ishii]

> 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?

No.

> 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.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hope that makes it a little clearer?
> 
> Thanks.
> 
> *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
> <http://simpro.com.au/legal/email-confidentiality-notice/>.
> 
> 
> 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
>> requirements.
>>
>> -dkw
>>
>> 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
>> 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*
>>
>> --
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
> 
> -- 
> --