From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Cc: | "Ken Brush *EXTERN*" <kbrush(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Multiple Slave Failover with PITR |
Date: | 2012-04-11 16:03:22 |
Message-ID: | CAL_0b1uTUp-0L2Kw0dsTUORF2O7h2YO2+9Q8hT+fG4ekminusw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Wed, Mar 28, 2012 at 11:35 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
>> 1. Master dies :(
>> 2. Touch the trigger file on the most caught up slave
If the master was stopped properly will the slaves be in sync to each other?
>> 3. Slave is now the new master.
>> 4. On the other slaves do the following:
>> 5. Shutdown postgres on the slave
>> 6. Delete every file in /data/pgsql/data/pg_xlog
>> 7. Modify the recovery.conf file to point to the new master and
>> include the line "recovery_target_timeline='latest'"
>> 8. Copy the history file from the new master to the slave (it's the
>> most recent #.history file in the xlog directory)
It will work in the case of archive_command presence only and I will
need to sync the whole pg_xlog content if do not have archive_command
in recovery.conf, correct?
>> 9. Startup postgres on the slave and watch it sync up to the new
>> master (about 1-5 minutes usually)
^^^
--
Sergey Konoplev
Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Nolan | 2012-04-11 16:09:51 | Re: [HACKERS] [streaming replication] 9.1.3 streaming replication bug ? |
Previous Message | Fujii Masao | 2012-04-11 15:56:11 | Re: [streaming replication] 9.1.3 streaming replication bug ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Nolan | 2012-04-11 16:09:51 | Re: [HACKERS] [streaming replication] 9.1.3 streaming replication bug ? |
Previous Message | Kevin Grittner | 2012-04-11 15:59:59 | Re: Last gasp |