Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 05E199FB5A5
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 18 Jul 2007 04:29:31 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 27901-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 18 Jul 2007 04:29:27 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75])
	by postgresql.org (Postfix) with ESMTP id BA2059FB32F
	for <pgsql-sql@postgresql.org>; Wed, 18 Jul 2007 04:29:27 -0300 (ADT)
Received: from server3.office.archonet.com
	(84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99])
	by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 2E5E774BF0;
	Wed, 18 Jul 2007 08:28:37 +0100 (BST)
Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36])
	by server3.office.archonet.com (Postfix) with ESMTP id 6742D274059;
	Wed, 18 Jul 2007 08:28:38 +0100 (BST)
Message-ID: <469DC124.8000704@archonet.com>
Date: Wed, 18 Jul 2007 08:28:36 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.0 (X11/20070326)
MIME-Version: 1.0
To: Jyoti Seth <jyotiseth2001@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Database Synchronization
References: <002d01c7c90b$48870560$d9951020$@com>
In-Reply-To: <002d01c7c90b$48870560$d9951020$@com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/111
X-Sequence-Number: 28846

Jyoti Seth wrote:
> Hello ,
> 
>  
> 
> I have two postgres databases on different linux servers. Postgres database
> on one server has some tables that needs to be synchronized from the other
> postgres database . What should be the best method for this.

The slony replication package lets you choose what tables you replicate. 
On the destination server the tables will be read-only.

http://www.slony.info/

Take a little time to read through the documentation and experiment with 
a test system first. It works fine, but it's got a lot of complicated 
options.

-- 
   Richard Huxton
   Archonet Ltd