Was looking at this:

    If you use pg_terminate_backend() to stop a backend, this will
trigger a failover. The reason why this happens is that PostgreSQL sends
exactly the same message for a terminated backend as for a full
postmaster shutdown. There is no workaround as of today. Please do not
use this function.

... and it occurred to me that there's a fix for this.  Instead of
automatically assuming failover, we could try to reconnect to that
server and only initiate failover if we can't reconnect.  Any reason
that wouldn't work?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to