From ketema@gmail.com Tue May 9 00:37:53 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6E5789FA15C for ; Mon, 8 May 2006 21:37:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 35183-05 for ; Mon, 8 May 2006 21:37:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.198]) by postgresql.org (Postfix) with ESMTP id 3D1D19F9D82 for ; Mon, 8 May 2006 21:37:43 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s13so998950wxc for ; Mon, 08 May 2006 17:37:42 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:user-agent:date:subject:from:to:message-id:thread-topic:thread-index:mime-version:content-type; b=Y5YgZxdQiNsOLwuDeUMc9ZDW65hwpegwEL4w9ZfdWq2YLqSgqD5Vcc939MJ+H/YRHYnL84axwigkaXgO7IlYY+ym8f3M00ZuVoXbieI7lP9CRd7PRCzXEnk9+GTrjjZ+pf3h9ZYOfEPFDEqUWq8DbWR7WEMBvUEcpr3j7x1CaQ8= Received: by 10.70.105.20 with SMTP id d20mr3113951wxc; Mon, 08 May 2006 17:37:42 -0700 (PDT) Received: from ?192.168.0.12? ( [24.227.61.54]) by mx.gmail.com with ESMTP id i38sm2901783wxd.2006.05.08.17.37.41; Mon, 08 May 2006 17:37:42 -0700 (PDT) User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Mon, 08 May 2006 20:37:32 -0400 Subject: Synchronized Replication From: Ketema Harris To: "pgsql-admin@postgresql.org" Message-ID: Thread-Topic: Synchronized Replication Thread-Index: AcZzAMIVAF07qN70EdqTBAARJHlfcA== Mime-version: 1.0 Content-type: multipart/alternative; boundary="B_3229965462_5305505" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/75 X-Sequence-Number: 21607 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3229965462_5305505 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Hello. I have been reading up on Sony Replication, and at first I thought Master/Slave between two offices would be perfect for my situation. After I got more info though I believe it may not suit my needs. If I want the two databases to be in synchronization (meaning they have the same tables, and if an insert occurs on one it is replicated in such a way that unique ids from sequences are not duplicated) is this something that Slony can accomplish? If not what other options are out there? Thanks. --B_3229965462_5305505 Content-type: text/html; charset="US-ASCII" Content-transfer-encoding: quoted-printable Synchronized Replication Hello.  I have be= en reading up on Sony Replication, and at first I thought Master/Slave betwe= en two offices would be perfect for my situation.  After I got more inf= o though I believe it may not suit my needs.  If I want the two databas= es to be in synchronization (meaning they have the same tables, and if an in= sert occurs on one it is replicated in such a way that unique ids from seque= nces are not duplicated) is this something that Slony can accomplish?  = If not what other options are out there?

Thanks.
--B_3229965462_5305505-- From jnasby@pervasive.com Mon May 15 19:35:26 2006 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EDEB39FA19B for ; Mon, 15 May 2006 16:35:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 35671-06 for ; Mon, 15 May 2006 16:35:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 8E8209FA15C for ; Mon, 15 May 2006 16:35:20 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id E796E56427; Mon, 15 May 2006 14:35:18 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 15 May 2006 14:35:18 -0500 Date: Mon, 15 May 2006 14:35:18 -0500 From: "Jim C. Nasby" To: Ketema Harris Cc: "pgsql-admin@postgresql.org" Subject: Re: Synchronized Replication Message-ID: <20060515193518.GF26212@pervasive.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060515:ketema@gmail.com::s8gFvUEZJtQjRLv+:01Vut X-Hashcash: 1:20:060515:pgsql-admin@postgresql.org::jKVCVlZPGe74of6C:00000000000 00000000000000000000000075aV X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/195 X-Sequence-Number: 21727 On Mon, May 08, 2006 at 08:37:32PM -0400, Ketema Harris wrote: > Hello. I have been reading up on Sony Replication, and at first I thought > Master/Slave between two offices would be perfect for my situation. After I > got more info though I believe it may not suit my needs. If I want the two > databases to be in synchronization (meaning they have the same tables, and > if an insert occurs on one it is replicated in such a way that unique ids > from sequences are not duplicated) is this something that Slony can > accomplish? If not what other options are out there? For slony, depening on how your application is setup, you might be able to have each site write to a set of local tables that are then replicated back to a single office. The database at that office would then need to merge all of that together and publish it back out via a different table. Your only other option is one of the command-based syncronous replication schemes, but you have to be very careful about what commands you issue with those. They also tend not to handle communication interruptions very well, making them ill-suited for replicating over a WAN. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461