Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 4476B9FB631
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 25 Jul 2007 07:16:03 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 98966-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 25 Jul 2007 07:15:45 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.236])
	by postgresql.org (Postfix) with ESMTP id DB0829FB5FB
	for <pgsql-sql@postgresql.org>; Wed, 25 Jul 2007 07:15:54 -0300 (ADT)
Received: by qb-out-0506.google.com with SMTP id o12so12888121qba
	for <pgsql-sql@postgresql.org>; Wed, 25 Jul 2007 03:15:53 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:from:to:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language;
	b=eSS8QH57h91brZTr+bQe/qVa20dIZIFCCE9y7CLERVckX7CPXaTAM6e4a3mcvnsFwtgqFTxaDetNnoPFn6QJOd9LppEJRN1fKCDv6UafvvLdKIS9hCTP40ijjQ/0ZnfIYBqXe2qfujLnC2JO6P4/CAdDy2pXYyUub0BM1zGxzX8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:from:to:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language;
	b=EZyCkrPx72jMdaa041SUCQ3w3d41gswLcw7tDXxEmlS+DDWtijhNrSi0NaHaA0aWCxY4+jwoDg5cGIa9iLuGarUDPg9VJt3eR6P+dHXcGFbqyWxydr/HEus4867SSi7l/hRVnryH9vCwd25eoH6Hc03E9e61+HGRas6iJ77wcc8=
Received: by 10.114.135.1 with SMTP id i1mr487869wad.1185358552644;
	Wed, 25 Jul 2007 03:15:52 -0700 (PDT)
Received: from bitdldt04 ( [122.162.169.176])
	by mx.google.com with ESMTPS id v35sm838175wah.2007.07.25.03.15.50
	(version=SSLv3 cipher=RC4-MD5); Wed, 25 Jul 2007 03:15:51 -0700 (PDT)
From: "Jyoti Seth" <jyotiseth2001@gmail.com>
To: <pgsql-sql@postgresql.org>
References: <20070724143737.GA25948@apartia.fr>
In-Reply-To: <20070724143737.GA25948@apartia.fr>
Subject: Database synchronization
Date: Wed, 25 Jul 2007 15:42:41 +0530
Message-ID: <004e01c7cea4$58046570$080d3050$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcfOALQVjwm19UlTSNiQ79CHHbqCugAoWOQw
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/143
X-Sequence-Number: 28878

Hi,

I have two postgres databases "Db1" and "Db2" on different linux servers.
"DB1" is my master server and its data updates very frequently.

My application access DB2 database, which in turn requires data from Db1
database. 

The same can be achieved in either of the following ways:
1. I can have the same tables from Db1 in the Db2 database and use some
replication process to update these tables say using Slony-I. And then our
application accesses the data from the single database.

2. Or I can use dblink to fetch the data from the master database only.

My problem is my master database changes frequently and I always require the
latest information.

Please suggest which is the right approach in this situation.

Thanks,
Jyoti Seth