| From: | "Burgholzer, Robert (DEQ)" <Robert(dot)Burgholzer(at)deq(dot)virginia(dot)gov> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: safe to clear pg_xlog archive status directory? |
| Date: | 2012-12-27 22:01:06 |
| Message-ID: | 77F5F8FA4B407F43BFCFD3FC347896913CAC1F@COVMSGCES-MBX01 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Baptiste LHOSTE | 2012-12-28 09:11:28 | Re: Autovacuum issues with truncate and create index ... |
| Previous Message | Carlos Balam | 2012-12-27 21:11:16 | unregister |