I thought pgreplicator did provide multi-master replication and i did test it as well.
http://pgreplicator.sourceforge.net/
vishOn 11/3/05, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:> > It seems kludgey this way, though. What you real
>> But if someone decided to "fork" their own *new* project, perhaps
>> starting based on one of the releases, that would an entirely
>> interesting idea.
>
> Wouldn't async multimaster make use of most all of what slony-I
> currently has? ISTM that it would make life a lot easier to use one
> comb
On Thu, Nov 03, 2005 at 10:29:56PM -0500, Christopher Browne wrote:
> > On Wed, Nov 02, 2005 at 03:44:26PM -0800, Marc Munro wrote:
> >> experts there may suggest a better solution. I have seen talk of
> >> disabling the standard slony triggers to allow this sort of thing but
> >> whether that is
> On Wed, Nov 02, 2005 at 03:44:26PM -0800, Marc Munro wrote:
>> experts there may suggest a better solution. I have seen talk of
>> disabling the standard slony triggers to allow this sort of thing but
>> whether that is more or less nasty is questionable.
>
> FWIW, I don't think that's the quest
> On Thu, Nov 03, 2005 at 04:49:33PM -0500, Andrew Sullivan wrote:
>> On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:
>> > > It seems kludgey this way, though. What you really need is
>> > > multimaster with conflict resolution, because you can depend on your
>> >
>> > Isn't Slony2
On Thu, Nov 03, 2005 at 04:49:33PM -0500, Andrew Sullivan wrote:
> On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:
> > > It seems kludgey this way, though. What you really need is
> > > multimaster with conflict resolution, because you can depend on your
> >
> > Isn't Slony2 suppose
On Thu, Nov 03, 2005 at 08:16:01AM -0800, codeWarrior wrote:
> It doesnt sound to me like replication is the right answer to this
> problem... You are setting yourself up to try and defeat one of the major
> purposes of a database in a client-server system -- namely -- centralized
> storage.
Wh
On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:
> > It seems kludgey this way, though. What you really need is
> > multimaster with conflict resolution, because you can depend on your
>
> Isn't Slony2 supposed to do just that?
Well, to the extent that slony 2 ever is going to do an
On Wed, Nov 02, 2005 at 03:44:26PM -0800, Marc Munro wrote:
> experts there may suggest a better solution. I have seen talk of
> disabling the standard slony triggers to allow this sort of thing but
> whether that is more or less nasty is questionable.
FWIW, I don't think that's the question; it
It doesnt sound to me like replication is the right answer to this
problem... You are setting yourself up to try and defeat one of the major
purposes of a database in a client-server system -- namely -- centralized
storage.
If you add up all the money you are going to spend trying to manage mul
Carlos Benkendorf schrieb:
> Hello,
>
> Currently our company has a lot of small stores distributed around the
> country and in the actual database configuration we have a central
> database and all the small stores accessing it remotely.
>
Hello Carlos,
There is a number of replication solut
Carlos,
What you are asking for is a multi-master replication scheme. Slony-I
is a single master system, meaning that for each slony cluster only one
node can make changes to the data.
Without breaking slony's normal rules, I believe that there might be a
way to do it, though it will not be prett
On Wed, Nov 02, 2005 at 05:45:40PM -0500, Andrew Sullivan wrote:
> On Wed, Nov 02, 2005 at 12:06:36PM +, Carlos Benkendorf wrote:
> > I would appreciate suggestions about how the best way to implement
> > such soluction.
> >
> > Slony-1? SQL scripts?
>
> Maybe a combination. My natural incl
On Wed, Nov 02, 2005 at 12:06:36PM +, Carlos Benkendorf wrote:
> I would appreciate suggestions about how the best way to implement
> such soluction.
>
> Slony-1? SQL scripts?
Maybe a combination. My natural inclination would be to try to do
this with some tricky views+rules so that each st
Hello,
Currently our company has a lot of small stores distributed around the country and in the actual database configuration we have a central database and all the small stores accessing it remotely.
All primary key tables were designed with a column identifying the store that it belongs. In
15 matches
Mail list logo
