Re: safe to clear pg_xlog archive status directory? - Mailing list pgsql-admin

From Burgholzer, Robert (DEQ)
Subject Re: safe to clear pg_xlog archive status directory?
Date
Msg-id 77F5F8FA4B407F43BFCFD3FC347896913CAC1F@COVMSGCES-MBX01
Whole thread Raw
In response to Re: safe to clear pg_xlog archive status directory?  ("Burgholzer, Robert (DEQ)" <Robert.Burgholzer@deq.virginia.gov>)
List 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

 

pgsql-admin by date:

Previous
From: Carlos Balam
Date:
Subject: unregister
Next
From: Baptiste LHOSTE
Date:
Subject: Re: Autovacuum issues with truncate and create index ...