From: Scott Marlowe <scott.marlowe@gmail.com>
To: nalini <nalini@nic.in>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres replication
Date: Thu, 10 Jan 2008 09:19:58 -0600
Message-ID: <dcc563d10801100719q67aa0432l652d74661bbae5e8@mail.gmail.com> (raw)
In-Reply-To: <46b8ed581b47692a.478611ce@nic.in>
References: <46b8ed581b47692a.478611ce@nic.in>
On Jan 10, 2008 1:38 AM, nalini <nalini@nic.in> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, nalini@nic.in
Subject: Re: Postgres replication
In-Reply-To: <dcc563d10801100719q67aa0432l652d74661bbae5e8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox