Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToLVp-00030I-0p for pgsql-admin@arkaria.postgresql.org; Thu, 27 Dec 2012 22:01:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1ToLVn-0007v9-KP for pgsql-admin@arkaria.postgresql.org; Thu, 27 Dec 2012 22:01:11 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToLVm-0007v3-Hx for pgsql-admin@postgresql.org; Thu, 27 Dec 2012 22:01:10 +0000 Received: from cmailc.vita.virginia.gov ([166.67.65.183]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToLVj-0005j9-RD for pgsql-admin@postgresql.org; Thu, 27 Dec 2012 22:01:10 +0000 X-SBRS: None X-HAT: Group: RELAYLIST_WHITELIST, Policy: $RELAYED_WHITELIST X-IronPort-AV: E=Sophos;i="4.84,363,1355115600"; d="scan'208,217";a="298191350" Received: from unknown (HELO COVMSGCES-HUB02.cov.virginia.gov) ([10.192.2.218]) by CRelayC.vita.virginia.gov with ESMTP; 27 Dec 2012 17:01:06 -0500 Received: from COVMSGCES-MBX01.cov.virginia.gov ([10.192.2.206]) by COVMSGCES-HUB02.cov.virginia.gov ([10.192.2.218]) with mapi id 14.02.0318.004; Thu, 27 Dec 2012 17:01:05 -0500 From: "Burgholzer, Robert (DEQ)" To: "pgsql-admin@postgresql.org" Subject: Re: safe to clear pg_xlog archive status directory? Thread-Topic: [ADMIN] safe to clear pg_xlog archive status directory? Thread-Index: Ac3kUhONYbczAFHaQ3y9p6Sm85uQIwAAUoLQAAG3ZkAACMVOgA== Date: Thu, 27 Dec 2012 22:01:06 +0000 Message-ID: <77F5F8FA4B407F43BFCFD3FC347896913CAC1F@COVMSGCES-MBX01> References: <77F5F8FA4B407F43BFCFD3FC347896913CAB40@COVMSGCES-MBX01> <128EC501EB29514B87952686265BB9A50C7922@ORD2MBX02G.mex05.mlsrvr.com> <77F5F8FA4B407F43BFCFD3FC347896913CAB97@COVMSGCES-MBX01> In-Reply-To: <77F5F8FA4B407F43BFCFD3FC347896913CAB97@COVMSGCES-MBX01> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.173.211.198] Content-Type: multipart/alternative; boundary="_000_77F5F8FA4B407F43BFCFD3FC347896913CAC1FCOVMSGCESMBX01_" MIME-Version: 1.0 X-Pg-Spam-Score: -4.2 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_77F5F8FA4B407F43BFCFD3FC347896913CAC1FCOVMSGCESMBX01_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable In the interest of follow-up, my process seemed to safely accomplish the go= al of resynching my master and replicant in 8.3. Also, I put together a wi= ki page demonstrating how to verify that the replicant and master are at le= ast on the same page without having to take down the master and raise the r= eplicant. This is something that is nice to do when monitoring these thing= s if you are unsure of the perfection of your configuration: http://sifn.bse.vt.edu/sifnwiki/index.php/Db_warm_standy_verifying Robert Burgholzer Surface Water Modeler Virginia DEQ Office of Surface and Ground Water Supply 804-869-3066 --_000_77F5F8FA4B407F43BFCFD3FC347896913CAC1FCOVMSGCESMBX01_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

In the interest of fol= low-up, my process seemed to safely accomplish the goal of resynching my ma= ster and replicant in 8.3.  Also, I put together a wiki page demonstra= ting how to verify that the replicant and master are at least on the same page without having to take down the maste= r and raise the replicant.  This is something that is nice to do when = monitoring these things if you are unsure of the perfection of your configu= ration:

 

http://sifn.bse.vt= .edu/sifnwiki/index.php/Db_warm_standy_verifying

 

Robert  Burgholzer

Surface Water Modeler
Virginia DEQ Office of Surface and Ground Water Supply

804-869-3066

 

--_000_77F5F8FA4B407F43BFCFD3FC347896913CAC1FCOVMSGCESMBX01_--