Re: postgresql-R

Based on:

Postgres based Replication Projects

PG Replication

Postgres-R: Dr. Kemme's Site, Paper, Publications, Replication Work, The Horus Project and Emsemble


DRAGON: Database Replication based on Group Communication


The Slony-1 Project


PGCluster


DBBalancer


PostgreSQL Replicator: Tutorial, Paper, Techdocs


eRServer: Techdocs


DBMirror: Will be in the 7.3 contrib directory.


Usogres: Techdocs

From: http://gborg.postgresql.org/project/pgreplication/genpage.php?replication_research

I was under the impression that "Postgres-R" - I misspelled it as "postgresql-R" - is a database clustering software. I downloaded the sources for this and it's supposed to work with "spread." I apologize if I'm mistaken?

I will certainly take a look into Slony-1, as you suggest. Did you have any good links to this? Have you gone through an install on Solaris 9 w/Postgresl v8.0?

WAN != LAN, where my database server is not in the same city as the target system to cluster with; for my worse case scenario, could be from east coast to west coast.

Kind regards,

Jim C. Nasby wrote:

On Tue, Mar 07, 2006 at 03:29:37PM -0500, Louis Gonzales wrote:


Hello,
I was wondering if anybody has had much experience with postgresql-R, or
being able to do database replication in a WAN environment.
Basically, does anybody have any good links/docs on doing this with
Solaris 9, postgresql v8.0?


If I'm not mistaken, pgreplication (which I'm guessing is what you mean
by postgresql-R) is part of the basis for the upcomming Slony-II.

Right now, depending on what you mean by 'WAN', your best bet is
probably Slony-I. If you're not doing a large update volume and the
connections to your remote sites are reliable it should work OK.