pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (4+ messages)  latest in thread

Message-ID: <77F5F8FA4B407F43BFCFD3FC347896913CAB40@COVMSGCES-MBX01>
Permalink:  ../77F5F8FA4B407F43BFCFD3FC347896913CAB40@COVMSGCES-MBX01/
Also on:    postgresql.org/message-id/77F5F8FA4B407F43BFCFD3FC347896913CAB40@COVMSGCES-MBX01

 · 

reply

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