From: david@lang.hm
To: Gernot Schwed <Gernot.Schwed@onvista-group.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres replication
Date: Wed, 30 Apr 2008 13:47:00 -0700 (PDT)
Message-ID: <alpine.DEB.1.10.0804301345240.7807@asgard> (raw)
In-Reply-To: <OFB4D720DB.B9AF49FD-ONC125743B.00498F11-C125743B.00569F0D@onvista-group.de>
References: <OFB4D720DB.B9AF49FD-ONC125743B.00498F11-C125743B.00569F0D@onvista-group.de>
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
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-performance@postgresql.org
Cc: david@lang.hm, Gernot.Schwed@onvista-group.de
Subject: Re: Postgres replication
In-Reply-To: <alpine.DEB.1.10.0804301345240.7807@asgard>
* 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