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 D9D653A2B26 for ; Fri, 29 Oct 2004 16:28:12 +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 68415-02 for ; Fri, 29 Oct 2004 15:28:08 +0000 (GMT) Received: from mail.deg.cc (unknown [64.139.134.201]) by svr1.postgresql.org (Postfix) with ESMTP id E7EAA3A2B1B for ; Fri, 29 Oct 2004 16:28:07 +0100 (BST) Received: from deg.cc (kyle.deg.cc [198.70.16.205]) by mail.deg.cc (Postfix) with ESMTP id 6CEA85603A for ; Fri, 29 Oct 2004 11:28:03 -0400 (EDT) Message-ID: <418261A5.5060006@deg.cc> Date: Fri, 29 Oct 2004 11:28:37 -0400 From: Pallav Kalva User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.2) Gecko/20040308 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Replication Options. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/377 X-Sequence-Number: 15370 Hi , 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 ? Thanks! Pallav