Hany,
Actually IMHO the best way to do this is with database mirroring at the
backend. There is a project underway to provide mirroring but it is not
finished. Try on the hackers list to see the status, or
gborg.postgresql.org
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Hany Ziad
Sent: Wednesday, February 27, 2002 2:09 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] DB mirroring
Hi everyone,
I am new to the PostGres and I am writing in Java and JDBC.
My application consists of several sites, each with a DB server with
thin clients. When the user finishes work in a site, he moves towards
another site with the same architecture.
The problem I am facing is that the user needs to find his DB updated
in each site he logs into. He needs to find even the newest updates he
did in the previous site.
So, I thought about making the recent changes in the DB available on
an authenticated web site, that can be accessed when the user starts a
session and then the changes are downloaded and then reflected on to
the DB. When the user terminates the session, the updates he made are
uploaded to the web site for future use and so on.
Am I on the right track? If so, how can I monitor these changes?
How can I update the older DB?
Can "Batch updates" do the job?
Help pls,
H. ZIAD
incode co.
_____________________________________________
This message was sent using Menanet MenaMail. http://www.menanet.net
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)