<p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">My apologies if this question has been asked before , and <span style="font-size:14px;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;"> </span></span>looking for some guidance.</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">Configuration <span style="font-size:14px;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;"> </span></span>- <span style="font-size:14px;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;"> </span></span>3 nodes cluster (primary and 2 standby systems) <span style="font-size:14px;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;"> </span></span>with pgpool-II 4.3 and PostgreSQL 12</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">postgresql.conf off each systems. </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">checkpoint_timeout = 30min</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">checkpoint_completion_target = 0.9</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">wal_buffers = 16MB</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">wal_level = replica</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">password_encryption = md5</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">archive_mode = on</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">archive_command = 'test ! -f /var/lib/pgsql/archivedir/%f && cp %p /var/lib/pgsql/archivedir/%f'</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">hot_standby = on</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">max_wal_senders = 10</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">wal_keep_segments = 10</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">port = 5432</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">wal_log_hints = on</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">restore_command = 'cp /var/lib/pgsql/archivedir/%f %p'</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">archive_cleanup_command = 'pg_archivecleanup /var/lib/pgsql/archivedir %r'</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">include_if_exists = '/var/lib/pgsql/12/data/myrecovery.conf'</p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">I understand the pgpool-II myrecovery.conf overwriting the restore_command off each standby systems. </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">physical slot replication is being utilize across the 2 standby systems, letting pgpool-II perform this configuration with the appropriate pcp command <span style="font-size:14px;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">  </span></span></p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">Our issue is that off the primary server the dedicate disk reserve for postgres keeps filling up, especially the /var/lib/pgsql/archivedir folder. </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">My understanding the archive_cleanup_command action is only perform off the standby systems. </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">The way we are currently are managing the issue is by <span style="font-size:14px;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;"> </span></span>periodically performinf a pg_basebackup off the primary system to a backup folder and then performinnf the archive_cleanup_command manually looking for the .backup file in the archivedir  folder. </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">#! /bin/sh</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">export PATH=/usr/local/pgsql/bin:${PATH}</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">ARCHDIR=/usr/local/pgsql/archive</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">LASTWALPATH=`/bin/ls $ARCHDIR/*.backup | /bin/sort –r | /usr/bin/head -1`</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">if [ $LASTWALPATH = '' ]; then</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">echo 'NO label file found.'</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">exit 1</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">fi</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">LASTWALFILE=`/bin/basename $LASTWALPATH`</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">pg_archivecleanup $ARCHDIR $LASTWALFILE</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">stat=$?</span></span></p><p class="Default" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">echo 'Archivelog cleanup complete'</span></span></p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">exit $stat</span></span></p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;">I did several google search and unable to find nay relevant information around this subject in relation to pgpool-ii.  </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">What’s the proper way of managing the archivedir space off the primary system? </span></span></p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">What’s the best practice for this area and any guidance would be appreciated ? </span></span></p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">Thanks,</span></span></p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"> </p><p class="MsoNormal" style="-webkit-text-stroke-width:0px;background-color:rgb(255, 255, 255);border:0px;box-sizing:border-box;color:rgb(85, 85, 85);font-family:helvetica, arial, verdana, sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:400;letter-spacing:normal;margin:1em 0px !important;orphans:2;padding:0px;text-align:start;text-decoration-color:initial;text-decoration-style:initial;text-decoration-thickness:initial;text-indent:0px;text-transform:none;white-space:pre-line;widows:2;word-spacing:0px;"><span style="font-size:10pt;"><span style="border:0px;box-sizing:border-box;font-style:inherit;margin:0px;padding:0px;">Henri</span></span></p>