From: Evan Rempel <erempel@uvic.ca>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: PgPool-II - does it do re-connect?
Date: Mon, 10 May 2010 13:26:51 -0700
Message-ID: <4BE86C0B.4080808@uvic.ca> (raw)
In-Reply-To: <4BB32E2F.8030304@2ndquadrant.com>
References: <4BB32420.2080707@greenmice.info>
<4BB32E2F.8030304@2ndquadrant.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: erempel@uvic.ca
Subject: Re: PgPool-II - does it do re-connect?
In-Reply-To: <4BE86C0B.4080808@uvic.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox