On 10/18/2011 10:00 PM, Daniel Jabbour wrote:
> Hi,
>
> I have been playing with Slony for the last couple of days. I have it replicating successfully in our setup, but I'm trying to figure out how to replicate between two different database schemas on the master provider and subscriber databases.
>
> What I'm trying to accomplish:
>
> * I have 60 individual DBs which are really different instances of the same database schema with slightly different data.
> * I want to replicate two tables (T1 and T2) from each master (M1...M50) to a single subscriber (S), consolidating the data into a single database.
> * I do not want to merge the data, just namespace it separately into postgres schemas (M1's public.T1 goes to S's m1.T1)
>
> I see the add table command for slonik takes a fully qualified name, including the schema. However, how do I configure it to store to a different qualified name in the subscriber?

This is a feature that is on our TODO list somewhere, but at this point 
there are no detailed plans as to how and when it will be implemented.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin