[pgpool-general: 3364] Difference between Master and Primary nodes

Chris Beauchamp chris at chillibean.tv
Mon Dec 15 21:40:53 JST 2014

Hi PGPool list,

I'm new(ish) to both postgres and pgpool, but learning fast :)

I'm trying to setup streaming replication with pgpool, and doing automatic
failovers etc.

I've setup a mostly working configurations (lots of docker containers), and
a failing master will cause pgpool to promote another slave and then
re-direct the other slaves to the new master.

However, now, when I kill a slave, and the master *isn't* the first node in
the pool, I get failover_command called, but with the old and new master
ids set to the first node in the pool (which isn't the master in terms of
replication), and the old primary node id set the the second (which was the

I then end up with two master nodes, and everything replicating from the
wrong node.

Is this a bug or a feature? I guess I'm just not clear on the difference
between a master node and a primary node - the documentation doesn't seem
to be very clear, especially where streaming replication is concerned.




*Chris Beauchamp*
Systems Administrator
ChilliBean Ltd

22, D'Arblay Street, London, W1F 8EQ, United Kingdom
tel +44 (0)20 7479 7030  |  mobile +44 (0)7770 643582  |  email
chris at chillibean.tv

www.chillibean.tv  |  www.chillivault.tv  |  www.sohosoho.tv

This email and its attachments may be confidential and are intended solely
for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Chillibean Limited. If you are not the intended
 recipient of this email and its attachments, you must take no action based
upon them, nor must you copy or show them to anyone. Please contact the
sender if you believe you have received this email in error.

Chillibean Limited of 10 Livonia Street, London W1F 8AF, United Kingdom is
a limited company registered in England under No. 4775994 VAT Registration
No. 835 760 804.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141215/c0b85903/attachment.html>

More information about the pgpool-general mailing list