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 по дате отправления: