X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6E3EB9DCB73 for ; Tue, 7 Mar 2006 17:01:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29130-01 for ; Tue, 7 Mar 2006 17:01:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.linuxlouis.net (mx1.linuxlouis.net [70.88.107.105]) by postgresql.org (Postfix) with ESMTP id 7DB539DCA0A for ; Tue, 7 Mar 2006 17:01:49 -0400 (AST) Received: from [192.168.0.3] (wap.linuxlouis.net [70.88.107.106]) (authenticated bits=0) by mx1.linuxlouis.net (8.13.4/8.13.4) with ESMTP id k27L5HDU003419; Tue, 7 Mar 2006 16:05:17 -0500 Message-ID: <440DF3FF.9060001@linuxlouis.net> Date: Tue, 07 Mar 2006 15:58:39 -0500 From: Louis Gonzales User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Jim C. Nasby" , pgsql-admin@postgresql.org Subject: Re: postgresql-R References: <440DED31.1060704@linuxlouis.net> <20060307203530.GG58405@pervasive.com> In-Reply-To: <20060307203530.GG58405@pervasive.com> Content-Type: multipart/mixed; boundary="------------070202020703030702090204" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.04 required=5 tests=[AWL=0.039, HTML_MESSAGE=0.001] X-Spam-Score: 0.04 X-Spam-Level: X-Archive-Number: 200603/75 X-Sequence-Number: 20832 This is a multi-part message in MIME format. --------------070202020703030702090204 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Based on:

Postgres based Replication Projects

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.
  

--------------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--