Re: Replication

--- On Mon, 22/6/09, Gerry Reno <greno(at)verizon(dot)net> wrote:

> Have you ever tried any of the postgresql replication
> offerings? The only one that is remotely viable is slony and
> it is so quirky you may as well forget it. The rest are in
> some stage of decay/abandonment. There is no real
> replication available for postgresql. Postgresql needs to
> develop a real replication offering for postgresql. Builtin
> or a separate module.
>

There was a similar thread on the Ferrari mailing list last week; some chap asking why the FFX didn't have a big red button to "make the steering go light". Apparently it is too hard to drive, whereas the Fiat Punto is easy and has this magic technology.

Seriously though, we use slony here in production and whilst it can be a pain in the arse at times it's a solid piece of kit. And bucardo, mammoth, londisite, pgpool are all good solutions - as long as you make yourself familiar with the one(s) you choose.

I've used the binlog streaming replication in mysql before, but I wouldn't trust it with my employer’s data.