Comments on End Point Blog: Automatic migration from Slony to Bucardo

Grzegorz: The built in replication has some limi...

2010-02-02T10:53:31.290-05:00

Grzegorz:

The built in replication has some limitations - such as query cancellation and the replication is "all or nothing". You cannot replicate a single database or table inside of a PostgreSQL cluster using 9.0 replication, you *must* replicate everything.

There's still going to be a place for trigger-based replication for Postgres for some time into the future. I prefer Bucardo to Slony as well, for ease of installation and configuration, and the ability to create custom code hooks that trigger events based on what's actually happening in your replication stream.

For my part, I like Bucardo better. I find it'...

2010-02-02T09:43:05.365-05:00

For my part, I like Bucardo better. I find it's easier to manage and easier to keep running than Slony, and its feature set includes many things Slony can't do. For that matter, it also includes things replication in PostgreSQL 9.0 can't do. This post was already long enough without comparing Bucardo, Slony, and streaming replication, but that's an excellent topic for a later post.

what's the point anyway, with replication intr...

2010-02-02T03:21:14.984-05:00

what's the point anyway, with replication introduced in 9.0 ?
You didn't mentioned what might even be the reason for migrating from very stable slony to younger product such as bucardo.