Re: postgresql-R

Поиск
Список
Период
Сортировка
От Louis Gonzales
Тема Re: postgresql-R
Дата
Msg-id 440DF3FF.9060001@linuxlouis.net
обсуждение исходный текст
Ответ на Re: postgresql-R  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: postgresql-R  (Jim Nasby <jnasby@pervasive.com>)
Список pgsql-admin
Based on:<br /><p><b>Postgres based Replication Projects</b><ul><li><a
href="http://gborg.postgresql.org/project/pgreplication/projdisplay.php"><b>PGReplication</b></a><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>ReplicationWork</b></a>, <a
href="http://www.cs.cornell.edu/Info/Projects/HORUS/"><b>TheHorus Project</b></a> and <a
href="http://www.cs.cornell.edu/Info/Projects/Ensemble/"><b>Emsemble</b></a><li><a
href="http://www.inf.ethz.ch/department/IS/iks/research/dragon.html"><b>DRAGON</b></a>:Database Replication based on
GroupCommunication <li><a href="http://gborg.postgresql.org/project/slony1/projdisplay.php"><b>The Slony-1
Project</b></a><li><ahref="http://hiroshima.sraw.co.jp/people/mitani/jpug/pgcluster/en/"><b>PGCluster</b></a><li><a
href="http://sourceforge.net/projects/dbbalancer/"><b>DBBalancer</b></a><li><a
href="http://pgreplicator.sourceforge.net/"><b>PostgreSQLReplicator</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></a><li><a
href="http://gborg.postgresql.org/project/erserver/projdisplay.php"><b>eRServer:</b></a><a
href="http://techdocs.postgresql.org/installguides.php#rserv"><b>Techdocs</b></a><li><a
href="http://archives.postgresql.org/pgsql-patches/2002-02/msg00004.php"><b>DBMirror</b></a>:Will be in the 7.3 contrib
directory.<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></ul>From:  <a
class="moz-txt-link-freetext"
href="http://gborg.postgresql.org/project/pgreplication/genpage.php?replication_research">http://gborg.postgresql.org/project/pgreplication/genpage.php?replication_research</a><br
/>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
throughan install on Solaris 9 w/Postgresl v8.0?<br /><br /> WAN != LAN, where my database server is not in the same
cityas 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
Gonzaleswrote: </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 />

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: postgresql-R
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgresql-R