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 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
