Re: Database replication method

First question: Does the database need to be local to both locations? Could you use a front-end that connects to the same backend database from both campuses?  (Like a web front end?)  That's your easiest solution.

Main concern is to be able to continue to work during a network failure.
Internet connections are not very reliable in the area.

Next question is *if* that's not acceptable, do both locations need to be able to modify the database?

Yes

Going with your above description, and assuming there isn't a way to simplify your requirements, the page above points to the Bucardo project as a solution you'll want to look at:
<http://bucardo.org/wiki/Bucardo>

Thanks, my online research pointed me to the same direction also.


Yuksel

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice