[pgpool-general: 3965] Re: Archive Cleanup

[Jonathan Eastgate]

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?

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

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