On Thursday 10 January 2008 00:38:38 nalini 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. > > Pls suggest a solution > > with regards > > > Nalini S. Nautiyal Maybe you could use dblink (in contribs) or dbi-link (see pgfoundry) and create a db full of remote "views" each one being a join that retrieves all data for that table from all related databases/clusters ? /Kevin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
