[Pgpool-general] Replication and Failover

Gary Fu gfu at sigmaspace.com
Mon Oct 4 21:32:58 UTC 2010


  Hi,

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 ?  If so,
the question is how does my application know there is a failover ?

Thanks,
Gary


More information about the Pgpool-general mailing list