Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToGe1-0006np-Tn for pgsql-admin@arkaria.postgresql.org; Thu, 27 Dec 2012 16:49:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1ToGe0-0007bz-TS for pgsql-admin@arkaria.postgresql.org; Thu, 27 Dec 2012 16:49:20 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToGdz-0007br-QQ for pgsql-admin@postgresql.org; Thu, 27 Dec 2012 16:49:20 +0000 Received: from cmailb.vita.virginia.gov ([166.67.65.182]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ToGdw-0006BK-8I for pgsql-admin@postgresql.org; Thu, 27 Dec 2012 16:49:17 +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="564256091" Received: from unknown (HELO COVMSGCES-HUB01.cov.virginia.gov) ([10.192.2.205]) by CRelayB.vita.virginia.gov with ESMTP; 27 Dec 2012 11:49:12 -0500 Received: from COVMSGCES-MBX01.cov.virginia.gov ([10.192.2.206]) by COVMSGCES-HUB01.cov.virginia.gov ([10.192.2.205]) with mapi id 14.02.0318.004; Thu, 27 Dec 2012 11:49:04 -0500 From: "Burgholzer, Robert (DEQ)" To: "pgsql-admin@postgresql.org" Subject: safe to clear pg_xlog archive status directory? Thread-Topic: safe to clear pg_xlog archive status directory? Thread-Index: Ac3kUhONYbczAFHaQ3y9p6Sm85uQIw== Date: Thu, 27 Dec 2012 16:49:03 +0000 Message-ID: <77F5F8FA4B407F43BFCFD3FC347896913CAB40@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_77F5F8FA4B407F43BFCFD3FC347896913CAB40COVMSGCESMBX01_" 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_77F5F8FA4B407F43BFCFD3FC347896913CAB40COVMSGCESMBX01_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am working through getting a warm standby up and running. I have fumbled= a bit, including having a non responsive standby node for a hile, which le= d (I think) to a big pile of "ready" files in the "pg_xlog/archive_status" = directory. My thought is that I need to start fresh, so here is the proces= s that I envision (someone please let me know if I am making mental errors)= : #1 - turn off archiving on the master, restart #2 - shut down postgresql on the replicant #3 - clear the pg_xlog/archive_status/ dir, with an "rm pg_xlog/archive_sta= tus/*" command #4 - perform a fresh rsync backup of my master to my replicant #5 - bring my replicant back up into standby mode #6 - re-enable archiving on the master and restart the postmaster Thanks in advance, r.b. Robert Burgholzer Surface Water Modeler Virginia DEQ Office of Surface and Ground Water Supply 804-869-3066 --_000_77F5F8FA4B407F43BFCFD3FC347896913CAB40COVMSGCESMBX01_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am working through getting a warm standby up and r= unning.  I have fumbled a bit, including having a non responsive stand= by node for a hile, which led (I think) to a big pile of “ready”= ; files in the “pg_xlog/archive_status” directory.  My thought is that I need to start fresh, so here is the process that I en= vision (someone please let me know if I am making mental errors):

 

#1 – turn off archiving on the master, restart=

#2 – shut down postgresql on the replicant

#3 – clear the pg_xlog/archive_status/ dir, wi= th an “rm pg_xlog/archive_status/*” command

#4 – perform a fresh rsync backup of my master= to my replicant

#5 – bring my replicant back up into standby m= ode

#6 – re-enable archiving on the master and res= tart the postmaster

 

Thanks in advance,

r.b.

 

Robert  Burgholzer

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

804-869-3066

 

--_000_77F5F8FA4B407F43BFCFD3FC347896913CAB40COVMSGCESMBX01_--