[pgpool-general: 7522] Re: Recovery after failure on a single backend

Tatsuo Ishii 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.

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

More information about the pgpool-general mailing list