pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Louis Gonzales <louis.gonzales@linuxlouis.net>
To: Jim C. Nasby <jnasby@pervasive.com>
To: pgsql-admin@postgresql.org
Subject: Re: postgresql-R
Date: Tue, 07 Mar 2006 15:58:39 -0500
Message-ID: <440DF3FF.9060001@linuxlouis.net> (raw )
In-Reply-To: <20060307203530.GG58405@pervasive.com >
References: <440DED31.1060704@linuxlouis.net >
<20060307203530.GG58405@pervasive.com >
This is a multi-part message in MIME format.
--------------070202020703030702090204
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Based on:<br>
<p><b>Postgres based Replication Projects</b> </p>
<ul>
<li><a
href="http://gborg.postgresql.org/project/pgreplication/projdisplay.php"><b>PG
Replication</b></a> </li>
<li>Postgres-R: <a href="http://www.cs.mcgill.ca/%7Ekemme"><b>Dr .
Kemme's Site</b></a>, <a
href="http://www.cs.mcgill.ca/%7Ekemme/papers/vldb00.html"><b>Paper</b></a ;,
<a href="http://www.cs.mcgill.ca/%7Ekemme/publications.html"><b>Publications</b></a ;,
<a href="http://www.cs.mcgill.ca/%7Ekemme/disl/replication.html"><b>Replication
Work</b></a>, <a href="http://www.cs.cornell.edu/Info/Projects/HORUS/"><b>The
Horus Project</b></a> and <a
href="http://www.cs.cornell.edu/Info/Projects/Ensemble/"><b>Emsemble</b></a ;
</li>
<li><a
href="http://www.inf.ethz.ch/department/IS/iks/research/dragon.html"><b>DRAGON</b></... ;:
Database Replication based on Group Communication </li>
<li><a
href="http://gborg.postgresql.org/project/slony1/projdisplay.php"><b>The
Slony-1 Project</b></a> </li>
<li><a
href="http://hiroshima.sraw.co.jp/people/mitani/jpug/pgcluster/en/"><b>PGCluster</b><... ;
</li>
<li><a href="http://sourceforge.net/projects/dbbalancer/"><b>DBBalancer</b></a ;
</li>
<li><a href="http://pgreplicator.sourceforge.net/"><b>PostgreSQL
Replicator</b></a>: <a
href="http://pgreplicator.sourceforge.net/tutorial.html"><b>Tutorial</b></a ;,
<a href="http://pgreplicator.sourceforge.net/5074-69225.pdf"><b>Paper</b></a ;,
<a
href="http://techdocs.postgresql.org/installguides.php#replicator"><b>Techdocs</b></... ;
</li>
<li><a
href="http://gborg.postgresql.org/project/erserver/projdisplay.php"><b>eRServer:</b><... ;
<a href="http://techdocs.postgresql.org/installguides.php#rserv"><b>Techdocs</b></a ;
</li>
<li><a
href="http://archives.postgresql.org/pgsql-patches/2002-02/msg00004.php"><b>DBMirror</b>... ;:
Will be in the 7.3 contrib directory. </li>
<li><a href="http://usogres.good-day.net/"><b>Usogres</b></a ;: <a
href="http://techdocs.postgresql.org/installguides.php#usogres"><b>Techdocs</b></a&g... ;
</ul>
From:
<a class="moz-txt-link-freetext" href="http://gborg.postgresql.org/project/pgreplication/genpage.php?replication_research">http://gb... ;
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?<br>
<br>
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?<br>
<br>
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.<br>
<br>
Kind regards,<br>
<br>
<br>
Jim C. Nasby wrote:<br>
<blockquote cite="mid20060307203530.GG58405@pervasive.com" type="cite">
<pre wrap="">On Tue, Mar 07, 2006 at 03:29:37PM -0500, Louis Gonzales wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->
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.
</pre>
</blockquote>
<br>
</body>
</html>
--------------070202020703030702090204
Content-Type: text/x-vcard; charset=utf-8;
name="louis.gonzales.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="louis.gonzales.vcf"
begin:vcard
fn:louis
n:gonzales;louis
email;internet:louis.gonzales@linuxlouis.net
tel;home:248.943.0144
tel;cell:248.943.0144
x-mozilla-html:TRUE
version:2.1
end:vcard
--------------070202020703030702090204--
Attachments:
louis.gonzales.vcf (text/x-vcard, 168B) download
begin:vcard
fn:louis
n:gonzales;louis
email;internet:louis.gonzales@linuxlouis.net
tel;home:248.943.0144
tel;cell:248.943.0144
x-mozilla-html:TRUE
version:2.1
end:vcard
view thread (9+ messages) latest in thread
Message-ID: <440DF3FF.9060001@linuxlouis.net>
Permalink: ../440DF3FF.9060001@linuxlouis.net/
Also on: postgresql.org/message-id/440DF3FF.9060001@linuxlouis.net
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: louis.gonzales@linuxlouis.net, jnasby@pervasive.com
Subject: Re: postgresql-R
In-Reply-To: <440DF3FF.9060001@linuxlouis.net>
References: <440DED31.1060704@linuxlouis.net> <20060307203530.GG58405@pervasive.com> <440DF3FF.9060001@linuxlouis.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox