[pgpool-general: 6133] Re: PgPool in streaming replication mode without failover and primary down

[Tatsuo Ishii]

Andre,

I think his setting actually *allows* failover. Since his
failover_command is empty, no failover command gets executed and
standby is not promoted.

On the other hand, DISALLOW_TO_FAILOVER flag disables failover itself
but as a result client cannot connect to pgpool until the primary
comes up again.

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

> Wolf,
> Do you mind sharing relevant configuration and version of pgpool you are
> using? Do you have more than one slave?
> 
> I have tried the following combinations:
> 
> backend_flag0 = 'ALWAYS_MASTER|DISALLOW_TO_FAILOVER'
> backend_flag1 = 'DISALLOW_TO_FAILOVER'
> 
> backend_flag0 = 'ALWAYS_MASTER'
> backend_flag1 = 'DISALLOW_TO_FAILOVER'
> 
> backend_flag0 = 'ALWAYS_MASTER'
> backend_flag1 = 'ALLOW_TO_FAILOVER'
> 
> master_slave_mode = on
> master_slave_sub_mode = 'stream'
> 
> sr_check_period = 0 and default sr_check_period = 10
> health_check_period = 0
> failover_command = ''
> fail_over_on_backend_error = off and fail_over_on_backend_error = on
> 
> On Wed, Jun 20, 2018 at 8:40 AM, Wolf Schwurack <wolf at uen.org> wrote:
> 
>> Yes it is possible I have all my Pgpool hosts setup that way. My setup is
>> a streaming replica and I don't apply the failover.sh script. If the master
>> goes down pgpool fails over to the standby in readonly mode.
>>
>>
>> Wolfgang Schwurack
>> Database/System Administrator
>> Utah Education Network
>> 801-587-9444
>> wolf at uen.org
>>
>>
>>
>> On 6/19/18, 9:48 PM, "pgpool-general-bounces at pgpool.net on behalf of Bo
>> Peng" <pgpool-general-bounces at pgpool.net on behalf of pengbo at sraoss.co.jp>
>> wrote:
>>
>>     Which version of Pgpool-II do you use?
>>     It also happened by latest version of Pgpool-II 3.7.4?
>>
>>     On Tue, 19 Jun 2018 20:00:58 -0700
>>     Andre Piwoni <apiwoni at webmd.net> wrote:
>>
>>     > I have been trying to figure how can I configure PgPool with one
>> primary
>>     > and one hot-standby slave to route read-requests to hot-standby when
>>     > primary is down without any failover. Is it currently possible?
>> Please
>>     > don't ask why.
>>     >
>>     > Thank you,
>>     > Andre Piwoni
>>
>>
>>     --
>>     Bo Peng <pengbo at sraoss.co.jp>
>>     SRA OSS, Inc. Japan
>>
>>     _______________________________________________
>>     pgpool-general mailing list
>>     pgpool-general at pgpool.net
>>     http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>>