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

From William Temperley
Subject Re: Disconnected editing - versioning of databases
Date
Msg-id 439dc11e0904150627m6e20db03ife02d3c61f2caeea@mail.gmail.com
Whole thread Raw
In response to Re: Disconnected editing - versioning of databases  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-general
On Wed, Apr 15, 2009 at 9:34 AM, Dimitri Fontaine
<dfontaine@hi-media.com> wrote:
>> On Tue, 14 Apr 2009, William Temperley wrote:
>> > 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.
>
> Can you partition data on origin?
> If that's possible, then do it and use a schema per origin to simplify the
> administration thereafter, and "just" replicate some tables from orginin to UK
> and central data from UK to editing countries.
>

Thanks Dimitri, that might be the way forward for us. I guess that's
what's referred to in the Federated database on
http://wiki.postgresql.org/wiki/Londiste_Tutorial.
Eventually all data will need to find it's way into the main schema,
however. Once the multi-origin tables are replicated back to the UK
they could then be merged into this under supervision, though I'm not
sure what would happen to them once they were merged - I guess this
gives a multi-master situation.

>> Le Wednesday 15 April 2009, Greg Smith a écrit :
>> It sounds like you want an asynchronous master-slave database architecture
>> where the slaves can also send changes back to the master, but didn't know
>> that's what you should be looking for.
>>

That is what I was looking for, thanks Greg.

>
> If you're afraid about their complexity, try londiste and enjoy :)
> --
> dim
>

Londiste seems to be a consensus. It looks good -  modular,
configurable and it's Python! Cool.

Thanks again,

Will

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Performance of full outer join in 8.3
Next
From: SongDongyan
Date:
Subject: a question about postgresql server connection