pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres replication
3+ messages / 3 participants
[nested] [flat]
* Postgres replication
@ 2008-04-30 15:45 Gernot Schwed <Gernot.Schwed@onvista-group.de>
2008-04-30 20:47 ` Re: Postgres replication david@lang.hm
0 siblings, 1 reply; 3+ messages in thread
From: Gernot Schwed @ 2008-04-30 15:45 UTC (permalink / raw)
To: pgsql-performance
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?
Best regards
Gernot
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres replication
2008-04-30 15:45 Postgres replication Gernot Schwed <Gernot.Schwed@onvista-group.de>
@ 2008-04-30 20:47 ` david@lang.hm
2008-05-01 09:33 ` Re: Postgres replication Fujii Masao <masao.fujii@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: david@lang.hm @ 2008-04-30 20:47 UTC (permalink / raw)
To: Gernot Schwed <Gernot.Schwed@onvista-group.de>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres replication
2008-04-30 15:45 Postgres replication Gernot Schwed <Gernot.Schwed@onvista-group.de>
2008-04-30 20:47 ` Re: Postgres replication david@lang.hm
@ 2008-05-01 09:33 ` Fujii Masao <masao.fujii@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Fujii Masao @ 2008-05-01 09:33 UTC (permalink / raw)
To: ; +Cc: pgsql-performance
On Thu, May 1, 2008 at 5:47 AM, <david@lang.hm> wrote:
> 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.
How about pgpool-HA? It's a script that integrates pgpool and heartbeat.
http://pgfoundry.org/projects/pgpool/
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-05-01 09:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-30 15:45 Postgres replication Gernot Schwed <Gernot.Schwed@onvista-group.de>
2008-04-30 20:47 ` david@lang.hm
2008-05-01 09:33 ` Fujii Masao <masao.fujii@gmail.com>
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