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

Tatsuo Ishii ishii at postgresql.org
Mon Dec 15 23:12:15 JST 2014

Probably there's something wrong with your failover script.
Please show the pgpool.conf and the failover script.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

> 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
> master).
> 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.
> Thanks!
> Chris
> -- 
> *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.

More information about the pgpool-general mailing list