[pgpool-general: 1169] Re: Follow master logic
Tatsuo Ishii
ishii at postgresql.org
Fri Nov 9 13:56:48 JST 2012
> 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
More information about the pgpool-general
mailing list