From: | Louis Gonzales <louis(dot)gonzales(at)linuxlouis(dot)net> |
---|---|
To: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: postgresql-R |
Date: | 2006-03-07 20:58:39 |
Message-ID: | 440DF3FF.9060001@linuxlouis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 4.0 KB |
louis.gonzales.vcf | text/x-vcard | 170 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-07 21:11:43 | Re: postgresql-R |
Previous Message | Jim C. Nasby | 2006-03-07 20:35:30 | Re: postgresql-R |