Date: Wed, 30 Apr 2008 13:47:00 -0700 (PDT)
From: david@lang.hm
To: Gernot Schwed <Gernot.Schwed@onvista-group.de>
cc: pgsql-performance@postgresql.org
Subject: Re: Postgres replication
In-Reply-To: 
 <OFB4D720DB.B9AF49FD-ONC125743B.00498F11-C125743B.00569F0D@onvista-group.de>
Message-ID: <alpine.DEB.1.10.0804301345240.7807@asgard>
References: 
 <OFB4D720DB.B9AF49FD-ONC125743B.00498F11-C125743B.00569F0D@onvista-group.de>
User-Agent: Alpine 1.10 (DEB 962 2008-03-14)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

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