[pgpool-general: 6960] Re: auto_failback = on not working

Takuma Hoshiai hoshiai at sraoss.co.jp
Wed Apr 8 15:42:51 JST 2020

On Wed, 08 Apr 2020 14:04:59 +0800
hostmaster <hostmaster at mylinuxsite.com> wrote:

> Hi all,
> I have a 2 node setup (2 pgpool and 2 Postgresql9.6)  At the start
> there is a primary and standby.  I then stop the standby database and
> then restart it after a while. After more than 60 seconds.  I check the
> status using 'show pool nodes'. The result is that the standby is still
> down. 
> My understanding is that if you set the auto_failback = on pgpool will
> automatically attach the standby. Is my understanding correct?
> Appreciate any help.  

I think that you should enable the feature of health check, because
auto failback need its process.

Best Regards,

Takuma Hoshiai <hoshiai at sraoss.co.jp>

More information about the pgpool-general mailing list