X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ED97F3A3BB6 for ; Fri, 29 Oct 2004 22:22:41 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81593-04 for ; Fri, 29 Oct 2004 21:22:31 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 1F39E3A3B9F for ; Fri, 29 Oct 2004 22:22:32 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i9TLMTJ7082830 for ; Fri, 29 Oct 2004 21:22:29 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i9TL40RL077868 for pgsql-admin@postgresql.org; Fri, 29 Oct 2004 21:04:00 GMT From: Chris Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Replication Options. Date: Fri, 29 Oct 2004 16:50:04 -0400 Organization: cbbrowne Computing Inc Lines: 40 Message-ID: <60y8hpntab.fsf@dba2.int.libertyrms.com> References: <418261A5.5060006@deg.cc> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:LbBrH61jx7za60tbaq6msrPG7h8= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/387 X-Sequence-Number: 15380 pkalva@deg.cc (Pallav Kalva) writes: > I need to implement the following the replication scenario in > postgres database. Here are the details of what we are looking to > implement. > > Lets say I have 2 nodes Node1(US) and Node2(Canada), > > Node1: tableA , tableB > Node2: tableB , tableA > > tableA in Node1 is the master and it should replicate only to slave > tableA in Node2 > > tableB in Node2 is the master and it should replicate only to slave > tableB in Node1 > > Can this be possible with any of the replication models available for > Postgres 7.4/8.0 ? This scenario would be supported by Slony-I; there are several ways to accomplish it, probably the easiest being thus... - Create two nodes, 1 and 2 - Create two replication sets - #1 and #2. - Set 1 has origin of node 1 - Set 2 has origin of node 2 - Add tablea to set 1 - Add tableb to set 2 - Subscribe node 2 to set 1 - Subscribe node 1 to set 2 Either node can run PG 7.4 or 8.0... -- let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];; http://slony.info A VAX is virtually a computer, but not quite.