On Jan 10, 2008 1:38 AM, nalini <nalini@xxxxxx> wrote: > Dear All > > I have a application running at various locations with backend as postgres > Slony is configured at all locations for replication at local site anda > central server where each site has its own database instance. > > Now we wish to merge data collected from all the sites into one database > instance to provide consolidated view > > database schema is same at all the places > However as the application is still under development the schema maychange. > however the change will happen at all the locations. I would replicate each one to a different schema on the same server and then use views to consolidate the data into what appears to be one set. To make everything unique, you could prepend a unique id to each identifier based on the schema it came from. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
