Re: Postgresql replication - Mailing list pgsql-general

From Jeff Davis
Subject Re: Postgresql replication
Date
Msg-id 430E136F.2010405@empires.org
Whole thread Raw
In response to Re: Postgresql replication  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Postgresql replication  (Carlos Henrique Reimer <carlosreimer@yahoo.com.br>)
List pgsql-general
Jim C. Nasby wrote:
> Or, for something far easier, try
> http://pgfoundry.org/projects/pgcluster/ which provides syncronous
> multi-master clustering.
>

He specifically said that pgcluster did not work for him because the
databases would be at physically seperate locations. PGCluster requires
that there be a load balancer and a replicator centrally located
managing the cluster. If a network problem happens at the centralized
location, it would bring down all locations completely.

I think he's looking for an async solution because of that. In my
solution, if one location goes down, the others keep going.

Regards,
    Jeff Davis

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: ctid access is slow
Next
From: William Yu
Date:
Subject: Re: Postgresql replication