<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; 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 id="OLK_SRC_BODY_SECTION">
<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">pgpool-general-bounces@pgpool.net</a>> on behalf of Jonathan Eastgate <<a href="mailto:jonathan.eastgate@simpro.co">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">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 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 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</b></div>
</div>
</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
-- </div>
</div>
</span>
</body>
</html>