On Fri, 2010-04-02 at 09:58 +0200, Iñigo Martinez Lasala wrote:
> I've never worked with Bucardo and Londiste, so I cannot give you any
> hint about it.
> With slony it's not necessary to restore all database prior staring
> sync process. You only have to restore your schema but not data. Slony
> will keep them synced with source server.
>
> Anyway, if you plan to migrate to 8.4 there are some issues with
> slony. For 8.3 and higher, you will go with slony 2.X. For 8.2 with
> slony 1.X
> I'm not sure if Slony 1.x is compatible with Postgres >= 8.3, but I'm
> sure slony 2.x is not backwards compatible.
Slony 1.2.17 and higher is compatible with PG 8.4. I'd go with the
latest stable release though.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.