Re: Database replication method

From: "Yuksel Pinarbasi" <yukselp(at)gmail(dot)com>
To: "PGSQL-Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Database replication method
Date: 2014-05-02 19:32:53
Message-ID: F0823C8D27C248038B3F9AC9EB2C9C7C@yukiPC
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Keith 2014-05-02 19:49:02 Re: Database replication method
Previous Message Daniel Staal 2014-05-02 19:13:32 Re: Database replication method