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

Re: Postgres replication

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: nalini <nalini(at)nic(dot)in>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres replication
Date: 2008-01-10 15:19:58
Message-ID: dcc563d10801100719q67aa0432l652d74661bbae5e8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Jan 10, 2008 1:38 AM, nalini <nalini(at)nic(dot)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.

In response to

Responses

pgsql-admin by date

Next:From: Antonio CorardiDate: 2008-01-10 17:53:05
Subject: physical memory
Previous:From: johnfDate: 2008-01-10 15:12:39
Subject: Re: find the sequence name from schema, table, field

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