Re: safe to clear pg_xlog archive status directory?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sorry - this was meant for the list:

Kris,

Thanks for the response and advice.  Unfortunately, I am operating on an 8.3 setup, so I do not think that this is available to me.  I am trying, of course, to get my head around migrating to the 9.x version, but am a little stuck right now - I need to weather the next month with my current setup (a high data collection period for us) and then tackle the task of upgrading.

 

Does my process, though obviously cumbersome, sound perilous?

 

Thanks again,

r.b.

 

 

From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Kris Bushover
Sent: Thursday, December 27, 2012 12:01 PM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: safe to clear pg_xlog archive status directory?

 

Rather than manually syncing the master to the slave, it would be better to use pg_basebackup (http://www.postgresql.org/docs/9.1/static/app-pgbasebackup.html).  This will copy the running master to the slave, and assuming the recovery.conf is in place on the slave, it can be restarted into recovery mode almost immediately.

 

From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Burgholzer, Robert (DEQ)
Sent: Thursday, December 27, 2012 10:49 AM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: safe to clear pg_xlog archive status directory?

 

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

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux