pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Jyoti Seth <jyotiseth2001@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Database synchronization
Date: Tue, 31 Jul 2007 09:22:04 +0100
Message-ID: <46AEF12C.2090107@archonet.com> (raw)
In-Reply-To: <6c3fb5eb0707310102s73bf7516w8dd157c550e2cf7d@mail.gmail.com>
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>

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



view thread (17+ messages)  latest in thread

Message-ID: <46AEF12C.2090107@archonet.com>
Permalink:  ../46AEF12C.2090107@archonet.com/
Also on:    postgresql.org/message-id/46AEF12C.2090107@archonet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dev@archonet.com, jyotiseth2001@gmail.com
  Subject: Re: Database synchronization
  In-Reply-To: <46AEF12C.2090107@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox