From: Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: safe to clear pg_xlog archive status directory?
Date: Thu, 27 Dec 2012 22:01:06 +0000
Message-ID: <77F5F8FA4B407F43BFCFD3FC347896913CAC1F@COVMSGCES-MBX01> (raw)
In-Reply-To: <77F5F8FA4B407F43BFCFD3FC347896913CAB97@COVMSGCES-MBX01>
References: <77F5F8FA4B407F43BFCFD3FC347896913CAB40@COVMSGCES-MBX01>
<128EC501EB29514B87952686265BB9A50C7922@ORD2MBX02G.mex05.mlsrvr.com>
<77F5F8FA4B407F43BFCFD3FC347896913CAB97@COVMSGCES-MBX01>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
In the interest of follow-up, my process seemed to safely accomplish the goal of resynching my master and replicant in 8.3. Also, I put together a wiki page demonstrating how to verify that the replicant and master are at least on the same page without having to take down the master 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 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Robert.Burgholzer@deq.virginia.gov
Subject: Re: safe to clear pg_xlog archive status directory?
In-Reply-To: <77F5F8FA4B407F43BFCFD3FC347896913CAC1F@COVMSGCES-MBX01>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox