[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
Japanese:http://www.sraoss.co.jp
> 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