From: Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: safe to clear pg_xlog archive status directory?
Date: Thu, 27 Dec 2012 16:49:03 +0000
Message-ID: <77F5F8FA4B407F43BFCFD3FC347896913CAB40@COVMSGCES-MBX01> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
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: <77F5F8FA4B407F43BFCFD3FC347896913CAB40@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