[pgpool-general: 1154] Follow master logic

Will Ferguson will.ferguson at vyre.com
Thu Nov 1 19:52:49 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?

Thanks,

Will
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121101/254dc395/attachment.html>


More information about the pgpool-general mailing list