Cleanup of same archive used by multiple standbys

From: A J <s5aly(at)yahoo(dot)com>
To: PG Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Cleanup of same archive used by multiple standbys
Date: 2011-08-10 16:41:25
Message-ID: 1312994485.73719.YahooMailNeo@web120017.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

What is the suggested technique for cleaning up an archive location shared by multiple standbys. Looks like pg_archivecleanup cannot be used as %r refers to last restartpoint of only a single standby server.
Do I need to create a custom script that somehow determines the latest common restartpoint of ALL the standbys and then manually run pg_archivecleanup with that value ?

Thanks.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message A J 2011-08-10 16:53:04 Re: Cleanup of same archive used by multiple standbys
Previous Message Jaime Casanova 2011-08-10 15:29:05 Re: Tentative release date for 9.1 and 9.2