From: Jyoti Seth <jyotiseth2001@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Database synchronization
Date: Wed, 25 Jul 2007 15:42:41 +0530
Message-ID: <004e01c7cea4$58046570$080d3050$@com> (raw)
In-Reply-To: <20070724143737.GA25948@apartia.fr>
References: <20070724143737.GA25948@apartia.fr>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jyotiseth2001@gmail.com
Subject: Re: Database synchronization
In-Reply-To: <004e01c7cea4$58046570$080d3050$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox