by david@[EMAIL PROTECTED]
Apr 30, 2008 at 01:47 PM
On Wed, 30 Apr 2008, Gernot Schwed wrote:
> Hi all,
>
> looking for a HA master/master or master/slave replication solution. Our
> setup consists of two databases and we want to use them both for
queries.
>
>
> Aside from pgpool II there seems no advisable replication solution. But
> the problem seems to be that we will have a single point of failure with
> pgpool. slony also has the disadvantage not to cover a real failover
> solution. Are there any other manageable and well tested tools/setups
for
> our scenario?
I'm about to setup a similar config and what I was intending to do is to
run pgpool on both boxes and use heartbeat (from http://linux-ha.org
) to
move an IP address from one box to the other. clients connect to this
virtual IP and then pgpool will distribute the connections to both systems
from there.
David Lang
--
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
