Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 555689FBA91 for ; Tue, 31 Jul 2007 05:22:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 56225-10 for ; Tue, 31 Jul 2007 05:22:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 5FDBA9FB5B7 for ; Tue, 31 Jul 2007 05:22:12 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 6C341144651; Tue, 31 Jul 2007 09:22:06 +0100 (BST) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 472D8274068; Tue, 31 Jul 2007 09:22:04 +0100 (BST) Message-ID: <46AEF12C.2090107@archonet.com> Date: Tue, 31 Jul 2007 09:22:04 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: Jyoti Seth Cc: pgsql-sql@postgresql.org Subject: Re: Database synchronization References: <20070724143737.GA25948@apartia.fr> <004e01c7cea4$58046570$080d3050$@com> <46A724CB.3030405@archonet.com> <000001c7cea8$39775d20$ac661760$@com> <46A7449A.4080500@archonet.com> <001e01c7cf40$85e7b540$91b71fc0$@com> <6c3fb5eb0707310102s73bf7516w8dd157c550e2cf7d@mail.gmail.com> In-Reply-To: <6c3fb5eb0707310102s73bf7516w8dd157c550e2cf7d@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/195 X-Sequence-Number: 28930 Jyoti Seth wrote: > Hello, > > I have one query related to slony-I. Can I replicate table data in different > schemas. Say if have table 'country' in database 'stock' and schema > 'stocksch'. And I want to replicate the data in table 'country' of database > 'smsdb' and schema 'smssch'. Here, the country table is present in two > different schemas. Can I replicate the country table data from schema > stocksch to schema smssch or I have to create a schema with the same name > for replication. I don't think slony lets you rename tables/schemas during transfer. I'm not sure many people want it, and it would be a complicated thing to do properly in the general case (you'll need to consider dependant objects - FKeys, views, functions etc). -- Richard Huxton Archonet Ltd