[pgpool-general: 6138] Re: Disable failover for a single pgpool/postgres node configuration

[Pierre Timmermans]

Hi,
There are a lot of parameters and it is indeed difficult to choose the right combination :-), so I am not sure neither.

>From my experiments, I see a difference if you set the flag DISALLOW_TO_FAILOVER versus ALLOW_TO_FAILOVER. 

with ALLOW_TO_FAILOVER, when the postgres database comes down pgpool will be detach it from the pool. But when the database is started again it won't be re-attached so you will have to do it manually.

with DISALLOW_TO_FAILOVER you don't have this problem, in fact can not use the pcp_detach_node functionality
So I believe setting DISALLOW_TO_FAILOVER is better in a single node set-up. I would also set fail_over_on_backend_error to no and health_check_period = 0 and failover_command = '' (empty string) and load_balance_mode = no
In a multi-node set-up, i found that having DISALLOW_TO_FAILOVER is not OK because then you cannot use pcp_detach (in case for example you would manually want to exclude one standby from the pool)


Regards,


Pierre 

    On Friday, June 22, 2018, 5:53:19 PM GMT+2, Alexander Dorogensky <amazinglifetime at gmail.com> wrote:  
 
 Hi,
I'm running pgpool 3.6.10 with postgres 9.6.8 in a single node configuration. Currently fail_over_on_backend_error = on, so I believe setting it to off will disable it?
Do I also have to set backend_flag0 to DISALLOW_FAILOVER?
Thanks_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180623/87e49254/attachment.html>