Re: Slony replication - Mailing list pgsql-general

From Vivek Khera
Subject Re: Slony replication
Date
Msg-id C6D37BBC-A0B4-49CA-90AB-376AD56F2253@khera.org
Whole thread Raw
In response to Re: Slony replication  (Geoffrey <lists@serioustechnology.com>)
List pgsql-general
On Dec 8, 2007, at 9:21 AM, Geoffrey wrote:

> I am quite new to Slony as well, but one of the first requirements
> the docs state is:
>
> Thus, examples of cases where Slony-I probably won't work out well
> would include:
>
>    * Sites where connectivity is really "flakey"
>    * Replication to nodes that are unpredictably connected.
>
> So I suspect Slony is not a solution for your effort.  See:

If your DB doesn't change very much (like a few hundred or thousand
update/insert/delete per day), then slony can work just fine in such a
batch mode.  Things break down when you accumulate several hundred
thousand or more changes between times when you're connected.


pgsql-general by date:

Previous
From: "Douglas McNaught"
Date:
Subject: Re: Simpler dump?
Next
From: Tino Wildenhain
Date:
Subject: Re: Simpler dump?