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