Re: postgresql-R

[Louis Gonzales <louis.gonzales@xxxxxxxxxxxxxx>]

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.
  

begin:vcard
fn:louis
n:gonzales;louis
email;internet:louis.gonzales@xxxxxxxxxxxxxx
tel;home:248.943.0144
tel;cell:248.943.0144
x-mozilla-html:TRUE
version:2.1
end:vcard