| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | Ken Brush <kbrush(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Multiple Slave Failover with PITR |
| Date: | 2012-04-11 16:50:10 |
| Message-ID: | CAL_0b1vp8K07pxxwLL4Vf-G1BeMKtGAuPOggnwAPJxM=czRT3g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Wed, Apr 11, 2012 at 8:12 PM, Ken Brush <kbrush(at)gmail(dot)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?
--
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 | Ken Brush | 2012-04-11 17:08:38 | Re: Multiple Slave Failover with PITR |
| Previous Message | Fujii Masao | 2012-04-11 16:35:55 | Re: [streaming replication] 9.1.3 streaming replication bug ? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Brush | 2012-04-11 17:08:38 | Re: Multiple Slave Failover with PITR |
| Previous Message | Tom Lane | 2012-04-11 16:48:00 | Re: Last gasp |