PgPool-II - does it do re-connect? - Mailing list pgsql-admin

From Evan Rempel
Subject PgPool-II - does it do re-connect?
Date
Msg-id 4BE86C0B.4080808@uvic.ca
Whole thread Raw
In response to Re: Any good olap benchmarks?  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-admin
I am looking ahead to when postgresql 9.x is non-beta and how
we can best make use of the "virtually synchronous" replication.

At our site, we have a load balancer appliance that works very well
in that it can direct a connection to one of a number
of back ends. When one back end goes away, connections will
be created to the remaining back ends. I think that this will
work well for the postgres failover, however, the database connection
will drop (I don't see how existing connections can be failed to the
hot-standby postgres server) and need to be established again.
Since I can not rely on the applications to perform the reconnect,
I was wondering if anyone knows if PgPool-II can accomplish this for
me. If it can, then the applications will not be aware that they have
been reconnected, they will just be aware that any outstanding transaction
failed.

Can anyone comment on this functionality of PgPool-II or on this
approach to failover in general?

Evan Rempel.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: List of postgreSQL databases
Next
From: Ray Stell
Date:
Subject: upgrade proc with pitr standby