Disconnected editing - versioning of databases - Mailing list pgsql-general

From William Temperley
Subject Disconnected editing - versioning of databases
Date
Msg-id 439dc11e0904140947v586a4ee2m75a9e7a3d2628164@mail.gmail.com
Whole thread Raw
Responses Re: Disconnected editing - versioning of databases
Re: Disconnected editing - versioning of databases
List pgsql-general
Hi All

I'm wondering if anyone can share any insights or experience with
temporary versions of databases, allowing "disconnected editing"
during Internet downtime.

The use-case is that I run a Postgres database, hosted in the UK, but
used by scientists in several other countries - Ecuador, Vietnam,
Kenya and Indonesia.
Unfortunately the connectivity between the UK and these countries is
flaky at best - perhaps usable 70% of the time. This means a lot of
wasted time for technicians and scientists working at remote
locations.

I could potentially run a database in each of these countries and
provide 100% uptime, obviously raising the issue of version conflicts
that would require hand-merging. Do people think this is feasible, or
a total non-starter? Performance is not an issue. Development time is
:)


Cheers

Will T

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Move databases from Pg 7.2.1 to 8.3.x
Next
From: John R Pierce
Date:
Subject: Re: Move databases from Pg 7.2.1 to 8.3.x