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
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"'... |