[Pgpool-general] Replication and Failover

[Tatsuo Ishii]

> I'm running pgpool2 3.0 with replication mode. I just noticed that
> when
> the pgpool failover (due to mismatch error) is done by shutting down
> the
> secondary db, my application failed due to the lost of connection.
> The documentation mention that when the failover is performed,
> pgpool kills all its child processes and starts new child processes
> for
> new connections from the clients.  Does this mean that my application
> has to make the new connection when the failover happens ?

Yes.

> If so,
> the question is how does my application know there is a failover ?

In this case libpq/your_favorite_driver returns error "server closed
the connection unexpectedly This probably means the server
terminated abnormally before or while processing the request."
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp