safe to clear pg_xlog archive status directory?

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: safe to clear pg_xlog archive status directory?
Date: 2012-12-27 16:49:03
Message-ID: 77F5F8FA4B407F43BFCFD3FC347896913CAB40@COVMSGCES-MBX01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 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 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_status/*" 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kris Bushover 2012-12-27 17:00:58 Re: safe to clear pg_xlog archive status directory?
Previous Message Kong Man 2012-12-26 22:56:54 Re: log_min_messages=debug5, despite an explicit setting to warning on postgresql.conf