[pgpool-general: 3965] Re: Archive Cleanup

Jonathan Eastgate jonathan.eastgate at simpro.co
Fri Aug 14 09:51:58 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?

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

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

More information about the pgpool-general mailing list