Re: Multiple Slave Failover with PITR
Sergey Konoplev <gray.ru@gmail.com>
From: Sergey Konoplev <gray.ru@gmail.com>
To: Ken Brush <kbrush@gmail.com>
Cc: pgsql-general@postgresql.org
Date: 2012-04-11T17:10:32Z
Lists: pgsql-hackers, pgsql-general
On Wed, Apr 11, 2012 at 9:08 PM, Ken Brush <kbrush@gmail.com> wrote: > On Wed, Apr 11, 2012 at 9:50 AM, Sergey Konoplev <gray.ru@gmail.com> wrote: >> On Wed, Apr 11, 2012 at 8:12 PM, Ken Brush <kbrush@gmail.com> wrote: >>>>>> 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? >>> >>> The new master will sync out the WAL logs from pg_xlog that the slaves >>> need. The wal sender/receiver system is what I rely on for this. >> >> So you do not have archive_command in recovery.conf, do you? >> > > Correct, I do not. Okay, thank you. Now things are much more clean. > > -Ken -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com LinkedIn: http://ru.linkedin.com/in/grayhemp JID/GTalk: gray.ru@gmail.com Skype: gray-hemp