From: Kevin Kempter <kevin@kevinkempterllc.com>
To: pgsql-admin@postgresql.org
Subject: Re: Postgres replication
Date: Thu, 10 Jan 2008 08:10:39 -0700
User-Agent: KMail/1.9.6 (enterprise 0.20071123.740460)
References: <46b8ed581b47692a.478611ce@nic.in>
In-Reply-To: <46b8ed581b47692a.478611ce@nic.in>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200801100810.39629.kevin@kevinkempterllc.com>

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