Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 071BEB5DC26 for ; Wed, 10 Aug 2011 13:41:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 53335-09 for ; Wed, 10 Aug 2011 16:41:27 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nm6-vm4.bullet.mail.ne1.yahoo.com (nm6-vm4.bullet.mail.ne1.yahoo.com [98.138.91.166]) by mail.postgresql.org (Postfix) with SMTP id 9A37BB5DBD6 for ; Wed, 10 Aug 2011 13:41:26 -0300 (ADT) Received: from [98.138.90.49] by nm6.bullet.mail.ne1.yahoo.com with NNFMP; 10 Aug 2011 16:41:25 -0000 Received: from [98.138.89.197] by tm2.bullet.mail.ne1.yahoo.com with NNFMP; 10 Aug 2011 16:41:25 -0000 Received: from [127.0.0.1] by omp1055.mail.ne1.yahoo.com with NNFMP; 10 Aug 2011 16:41:25 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 630619.26164.bm@omp1055.mail.ne1.yahoo.com Received: (qmail 22656 invoked by uid 60001); 10 Aug 2011 16:41:25 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1312994485; bh=kefl865kQp+hPdvc6Wi2Dh7KVh2YuK7A/U+kYOlSKAA=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=my6QfMpXuMNbbTBA6ry6YfgILYIpN5ub0r2kY684Wnjs7m4vV2HPQAu6IB8GjGtSuiSzivYsR609Qd6yvILUs8uazQs+tyh0Vy/kcSRMHp/PDEbfErltnFolzCf2IodUHrEdWxmsLjhgZogoPm3F1IesyjnoNbgzhwqNSR+RdDU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=kJIHzsS46R5xKeTN43r3SJGFe6lchiVpx3i/YVdy57Ci5KSYueud+kCGQ1YIjTQZw9bJw4Sucvv+W6YWu4XgegWpLA9XHY0p8KuINVYGVyYp+ddve+lR2kp7wNyeB1VYkU9cI4HbCpM9wUd2yS82rizV501ccPkUqhC4H0u8PBs=; X-YMail-OSG: kFLVEJQVM1l6d.cIhS6WaGoayWM7iIFCBpBoY9YPhKA7a6P U0cfd2XBfkYVsl0jE._g5nJ7GwoZE9YZDj_K.1OkRHQ4pKPaHhJXf89c1UOJ pPDVpG6t8_C3aiSMtt6bdHAgqMTCM9jvydIrJAss78lrdF1H9FFcnMWkbmzw sj8kT79n7FeJBgowVdQkm8CAlDpiPn_VOh_jCM0EKQwSzaGM1GuRIXPM72gM MfafI_QcSOP8Nc.Dw2OYv4f47dGaBwYVWPfr0kwB2zoXSyWQlDUQyegQCwUg fhUjU52YqINwz9BhnsX7etyIZu63xxf4xiDws22Ikf7m.Y.eFnPbNke0h7Zv 68vafzyazy.VewBxsAPoqQ0MRDRKks5BH Received: from [64.61.91.74] by web120017.mail.ne1.yahoo.com via HTTP; Wed, 10 Aug 2011 09:41:25 PDT X-Mailer: YahooMailWebService/0.8.113.313619 Message-ID: <1312994485.73719.YahooMailNeo@web120017.mail.ne1.yahoo.com> Date: Wed, 10 Aug 2011 09:41:25 -0700 (PDT) From: A J Reply-To: A J Subject: Cleanup of same archive used by multiple standbys To: PG Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1256317007-1311699774-1312994485=:73719" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.709 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.811 X-Spam-Level: X-Archive-Number: 201108/80 X-Sequence-Number: 38067 --1256317007-1311699774-1312994485=:73719 Content-Type: text/plain; charset=us-ascii 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. --1256317007-1311699774-1312994485=:73719 Content-Type: text/html; charset=us-ascii
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.
--1256317007-1311699774-1312994485=:73719--