Re: Remote Sync - Mailing list pgsql-general

From Simon Riggs
Subject Re: Remote Sync
Date
Msg-id 1142469297.3859.231.camel@localhost.localdomain
Whole thread Raw
In response to Remote Sync  ("Daniel Blaisdell" <lunk.djedi@gmail.com>)
Responses Re: Remote Sync
List pgsql-general
On Wed, 2006-03-15 at 17:12 -0500, Daniel Blaisdell wrote:
> I am currently in a situation where I have a distributed application
> between a few remote nodes all connecting to a central database. I
> have been searching for a database replication or synchronization
> system that will allow a disconnected node to operate independently of
> the central database. The ultimate intention of this type of system is
> to have an application operate off of data locally and have those
> changes synced in the background.
>
> >From the research I've done, Slony doesn't support multi-master
> writers. PGCluster and ExtenDB seem to require all nodes be next to
> each other with the ultimate goal of local load balancing.
>
> Are there any solutions that come close to the requirements I'm after?
>
> Thanks for any input,

Is this situation multi-master? If you partition your data at each
distributed node, then each is a single master to different data. You
can then make the central database the slave to multiple distributed
master databases.

Remote table1 -> central table1
Remote table2 -> central table2 etc

You can then link all the central tables together using:
- inheritance partitioning
- UNION ALL views

Best Regards, Simon Riggs


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: tsearch is slow
Next
From: Tom Lane
Date:
Subject: Re: question about postgresql time intervals