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? Thanks, Daniel -- Daniel Jabbour Senior Agnostic Algorithmatist Inigral, Inc. | The Social Web For Education drj | at | inigral | dot | com _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
