PostgreSQL local replication

From: Leonard Soetedjo <stelar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL local replication
Date: 2005-09-01 03:22:19
Message-ID: 1125544939.5492.12.camel@leonard.stelar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm currently using PostgreSQL 8.0.3 and would like to have a load-
balancing and failover solution over LAN.

>From reading the mailing list, it seems that pgpool and slony1
combination has been recommended for LAN replication. But seems that
pgcluster is still actively maintained? Which one should I proceed
with?

It seems that pgcluster is simpler to set up, and pgpool/slony1 seems to
have a few caveats (well, pgcluster might have too, but not stated). So
I think it's best to get some advice from the PostgreSQL folks.

Thanks,

Leonard

Browse pgsql-general by date

  From Date Subject
Next Message Casey T. Deccio 2005-09-01 04:06:23 Transaction error
Previous Message Chris Travers 2005-09-01 02:20:20 Re: newbie - postgresql or mysql