[pgpool-general: 4825] Re: master detach and slave attached without failover
ishii at postgresql.org
Tue Jul 26 15:57:40 JST 2016
I have never seen such that phenomena. Without seeing a concrete log
file when it happened, or you provide a self contained test case,
there's not much I can do.
SRA OSS, Inc. Japan
> 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
> 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