Re: Database replication method - Mailing list pgsql-novice

From Yuksel Pinarbasi
Subject Re: Database replication method
Date
Msg-id F0823C8D27C248038B3F9AC9EB2C9C7C@yukiPC
Whole thread Raw
In response to Re: Database replication method  (Daniel Staal <DStaal@usa.net>)
Responses Re: Database replication method  (Keith <keith@keithf4.com>)
List pgsql-novice
> 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



pgsql-novice by date:

Previous
From: Daniel Staal
Date:
Subject: Re: Database replication method
Next
From: Keith
Date:
Subject: Re: Database replication method