[pgpool-general: 4824] Re: master detach and slave attached without failover

Avi Weinberg AviW at gilat.com
Tue Jul 26 15:45:18 JST 2016


I want it to failover in case the master become detached.  I already had the value backend_flag0 = 'ALLOW_TO_FAILOVER' and backend_flag1 = 'ALLOW_TO_FAILOVER', but for some strange reason I saw twice that I have one server as master detached and the other server as slave attached.  I cannot understand why the slave did not become master when the master became detached.


-----Original Message-----
From: Tatsuo Ishii [mailto:ishii at postgresql.org]
Sent: Tuesday, July 26, 2016 7:36 AM
To: Avi Weinberg <AviW at gilat.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 4816] master detach and slave attached without failover

> Hi all,
> I have a setup with one master and one slave.  At rare cases I see
> that the master is detached and its partner is slave attached.  How
> come the master became detached without causing a failover.  When I
> try to detach a master manually it causes failover as expected.  What
> might be the scenario that caused it to me master detached without
> failover

You can set backend_flag0 = 'ALLOW_TO_FAILOVER' or something like that to prevent a fail over. See the manual for more details.

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

More information about the pgpool-general mailing list