Disconnected editing - versioning of databases

From: William Temperley <willtemperley(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Disconnected editing - versioning of databases
Date: 2009-04-14 16:47:34
Message-ID: 439dc11e0904140947v586a4ee2m75a9e7a3d2628164@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roderick A. Anderson 2009-04-14 16:58:48 Move databases from Pg 7.2.1 to 8.3.x
Previous Message Tom Lane 2009-04-14 16:42:27 Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...