[pgpool-general: 1169] Re: Follow master logic

[Tatsuo Ishii]

> Hi All,
> 
> I'm trying to understand how my follow master script should be written.
> 
> If I have 3 nodes in my cluster, 1 master (lets call it A) and 2 slaves (B
> & C).
> 
> My master A goes down, this then promotes slave B to master.
> 
> I then need to get the other slave C to follow the new master B.
> 
> My question is this, Is it sufficient for the follow master script to shut
> down the slave C, modify the recovery.conf so that it points to B, and then
> bring back up again, or do I need to perform a base backup of B onto C?

Yes, you need to perform backup of B onto C.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp