Postgres replication

From: nalini <nalini(at)nic(dot)in>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres replication
Date: 2008-01-10 07:38:38
Message-ID: 46b8ed581b47692a.478611ce@nic.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Allan Kamau 2008-01-10 10:30:29 using trigger (plpgsql) on table with default value in not null field.
Previous Message Suresh Gupta VG 2008-01-10 07:37:09 Need some info.