Skip site navigation (1) Skip section navigation (2)

Re: Postgres replication

From: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres replication
Date: 2008-01-10 15:10:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 ?


In response to

pgsql-admin by date

Next:From: johnfDate: 2008-01-10 15:12:39
Subject: Re: find the sequence name from schema, table, field
Previous:From: Alvaro HerreraDate: 2008-01-10 14:12:43
Subject: Re: find the sequence name from schema, table, field

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group