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:&nbsp;
<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.&nbsp; I downloaded the
sources for this and it's supposed to work with "spread."&nbsp; I apologize
if I'm mistaken?<br>
<br>
I will certainly take a look into Slony-1, as you suggest.&nbsp; Did you
have any good links to this?&nbsp; 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>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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

 · 

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