[pgpool-general: 7522] Re: Recovery after failure on a single backend
ishii at sraoss.co.jp
Sat Apr 24 02:15:45 JST 2021
>> 2) Enable auto_failback. Unlike #1, failover completes. But after some
>> period, the backend automatically becomes online again if connection
>> to the backend becomes healthy again.
> The documentation states that this option relies on streaming
> replication. We use this option in our cluster setup to automatically
> reattach backends when streaming is in sync again. I don't think it
> will work with a single backend because pgpool has no way of detecting
> that the connection is healthy again. The health checks don't seem to
> run on detached nodes.
You are right. Sorry for wrong suggestion.
SRA OSS, Inc. Japan
More information about the pgpool-general