Sat Sep 8 18:07:04 PDT 2007
- Previous message: [Slony1-general] failover doesn't remove triggers
- Next message: [Slony1-general] different masters for different tables
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, I'm looking at using slony for the first time. I'd like to know if it's possible to have different tables in a slave db replicated from different master db's. Just to outline the setup I'm looking at, I have (proposed) master db's that are distributed in various geographical areas for performance reasons that need to be replicated back to a central slave. The critical table in each master db (the only table needing to be replicated) would have an identical data structure and RI model (except for a constraint limiting the pk to that properly belonging to that particular master db). If possible the slave tables would actually be partitions of a "whole of system" slave db (ie, children in a table inheritance relationship) in order to provide a view of all the data in one slave table, though from a first reading of the docs I suspect this is not possible as the table schemas would be different from master to slave. Regards, Tim Bowden
- Previous message: [Slony1-general] failover doesn't remove triggers
- Next message: [Slony1-general] different masters for different tables
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list