Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id AEE1B2E319A
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 10 Jan 2008 03:42:47 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 62545-07 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 10 Jan 2008 03:42:41 -0400 (AST)
Received: from vastu8.nic.in (unknown [164.100.10.14])
	by postgresql.org (Postfix) with ESMTP id E87452E3326
	for <pgsql-admin@postgresql.org>; Thu, 10 Jan 2008 03:42:43 -0400 (AST)
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AgAAABZbhUfAqAFF/2dsb2JhbAAIgmembA
X-IronPort-AV: E=McAfee;i="5100,188,5203"; a="238607"
X-IronPort-AV: E=Sophos;i="4.24,265,1196620200";
   d="scan'208";a="238607"
Received: from unknown (HELO mail.nic.in) ([192.168.1.69])
	by int.nic.in with ESMTP; 10 Jan 2008 13:10:50 +0530
MIME-version: 1.0
Content-type: multipart/alternative;
	boundary="Boundary_(ID_CZiibeee9aZOcwif+bSr7A)"
Received: from msgfe1.nic.in ([127.0.0.1])
	by msgfe1.nic.in (Sun Java(tm) System Messaging Server 6.3-4.01 (built
	Aug 3
	2007; 32bit)) with ESMTP id <0JUF00GLF3WENF80@msgfe1.nic.in> for
	pgsql-admin@postgresql.org; Thu, 10 Jan 2008 13:08:38 +0530 (IST)
Received: from nic.in ([10.1.150.17])
	by msgfe1.nic.in (Sun Java(tm) System Messaging Server 6.3-4.01 (built
	Aug 3
	2007; 32bit)) with ESMTPA id <0JUF00DMF3WE6090@msgfe1.nic.in> for
	pgsql-admin@postgresql.org; Thu, 10 Jan 2008 13:08:38 +0530 (IST)
Received: from [10.1.150.17] by msgfe1.nic.in (mshttpd); Thu,
	10 Jan 2008 12:38:38 +0500
From: nalini <nalini@nic.in>
To: pgsql-admin@postgresql.org
Message-id: <46b8ed581b47692a.478611ce@nic.in>
Date: Thu, 10 Jan 2008 12:38:38 +0500
X-Mailer: Sun Java(tm) System Messenger Express 6.3-4.01 (built Aug  3 2007;
	32bit)
Content-language: en
Subject: Postgres replication
X-Accept-Language: en
X-TM-AS-Product-Ver: IMSS-7.0.0.3116-5.0.0.1023-15658.003
X-TM-AS-User-Approved-Sender: Yes
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/98
X-Sequence-Number: 27872

This is a multi-part message in MIME format.


--Boundary_(ID_CZiibeee9aZOcwif+bSr7A)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline

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




--Boundary_(ID_CZiibeee9aZOcwif+bSr7A)
Content-type: text/html; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline

Dear All<br><br>I have a application running at various locations with backend as postgres<br>Slony is configured at all locations for replication at local site anda central server where each site has its own database instance.<br><br>Now we wish to merge data collected from all the sites into one database instance to provide consolidated view<br><br>database schema is same at all the places<br>However as the application is still under development the schema maychange. however the change will happen at all the locations.<br><br>Pls suggest a solution<br><br>with regards<br><br><br>Nalini S. Nautiyal<br><br>

--Boundary_(ID_CZiibeee9aZOcwif+bSr7A)--