[Pgpool-general] rawmode failover

[Tatsuo Ishii]

> In rawmode, set up for failover per the docs, I find that after killing
> backend_hostname0, my first attempt to access the database via pgpool
> will fail, and the second attempt will succeed against
> backend_hostname1. Is this normal? I.e. is there a way to eliminate the
> initial failed connection after backend_hostname0 goes down?

Enabling health checking should help you. If the health checking find
backend goes down, it will trigger failover immediately, rather than
"first attempt to access the database via pgpool". So next attempt to
connect pgpool will success.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp