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