<div dir="ltr">Hi guys.<div><br></div><div>Thanks for those replies.</div><div><br></div><div>Not quite what I'm questioning though so let me try and explain better.</div><div><br></div><div>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?</div><div><br></div><div>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?</div><div><br></div><div>Hope that makes it a little clearer?</div><div><br></div><div>Thanks. </div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><span style="border-collapse:collapse"><div><div style="font-size:13.33px"><b style="font-family:Arial">Jonathan J. Eastgate</b><br></div><div style="font-size:13.33px"><div><span style="border-collapse:collapse"><span style="font-family:arial,helvetica,sans-serif;font-size:13.33px">Chief Technology Officer</span><font face="Arial"> | simPRO Software Group<br><span style="font-family:arial,sans-serif;font-size:13.33px">Ph: </span><a style="font-family:arial,sans-serif;font-size:13.33px" value="+611300139467">1300 139 467</a><span style="font-family:arial,sans-serif;font-size:13.33px"> </span><a style="font-family:arial,sans-serif;font-size:13.33px" value="+61730405572">+61 7 3147 8777</a></font></span></div><div><span style="border-collapse:collapse"><font face="Arial"><a style="font-family:arial,sans-serif;font-size:13.33px" value="+61730405572"><br></a></font></span></div><div><span style="border-collapse:collapse"><font face="Arial"><a style="font-family:arial,sans-serif;font-size:13.33px" value="+61730405572"><img src="http://simprogroup.com/media/thejourneyemailsig.png"><br></a></font></span></div><div><font color="#000000" face="Arial"><br></font><font face="arial, helvetica, sans-serif"><font face="Arial">Keep up to date with simPRO at: </font><font face="Arial"><a style="color:rgb(17,85,204)" href="http://simpro.co/blog" target="_blank">simpro.co/blog</a></font><br></font><font color="#ababab" face="arial, helvetica, sans-serif" size="1">The contents of this email are subject to our <a style="color:rgb(17,85,204)" href="http://simpro.com.au/legal/email-confidentiality-notice/" target="_blank">email disclaimer</a>.</font></div></div></div><div><br></div></span></div></div></div></div></div>
<br><div class="gmail_quote">On Fri, Aug 14, 2015 at 2:03 AM, Darryl Wisneski <span dir="ltr"><<a href="mailto:darryl.wisneski@finalsite.com" target="_blank">darryl.wisneski@finalsite.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>
<div style="font-family:Consolas,monospace;font-size:12px">gzip in the archive_command helps with disk usage.</div>
<div style="font-family:Consolas,monospace;font-size:12px"><br>
</div>
<div style="font-family:Consolas,monospace;font-size:12px">A daily basebackup out of cron would enable you to nuke WALs older than the most recent basebackup’s 'backup history file.'</div>
<div style="font-family:Consolas,monospace;font-size:12px"><br>
</div>
<div style="font-family:Consolas,monospace;font-size:12px">Adjust your WAL and basebackup archive retention based on business requirements.</div>
</div>
<div style="font-family:Consolas,monospace;font-size:12px"><br>
</div>
<div style="font-family:Consolas,monospace;font-size:12px">-dkw</div>
<div><br>
</div>
<span>
<div style="font-family:Calibri;font-size:11pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span><<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.net</a>> on behalf of Jonathan Eastgate <<a href="mailto:jonathan.eastgate@simpro.co" target="_blank">jonathan.eastgate@simpro.co</a>><br>
<span style="font-weight:bold">Date: </span>Wednesday, August 12, 2015 at 10:44 PM<br>
<span style="font-weight:bold">To: </span>pgpool-general <<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>><br>
<span style="font-weight:bold">Subject: </span>[pgpool-general: 3958] Archive Cleanup<br>
</div>
<div><br>
</div>
<div>
<div><div><div class="h5">
<div dir="ltr">Hi everyone.
<div><br>
</div>
<div>We have a successful PGPoolII installation running nicely using streaming replication.</div>
<div><br>
</div>
<div>However we're trying to work out what we need to keep in our WAL archives - as these are filling up quickly.</div>
<div><br>
</div>
<div>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?</div>
<div><br>
</div>
<div>Would be interested to know how people are handling this?</div>
<div><br>
</div>
<div>Thanks</div>
<div><br clear="all">
<div>
<div>
<div dir="ltr">
<div>
<div dir="ltr"><span style="border-collapse:collapse">
<div>
<div style="font-size:13.33px"><b style="font-family:Arial">Jonathan</b></div>
</div>
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
<br></div></div>
-- </div>
</div>
</span>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>
<br>
--