Re: Migrate postgres to newer hardware - Mailing list pgsql-admin

From Brad Nicholson
Subject Re: Migrate postgres to newer hardware
Date
Msg-id 1270470597.19810.2.camel@bnicholson-desktop
Whole thread Raw
In response to Re: Migrate postgres to newer hardware  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
List pgsql-admin
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.



pgsql-admin by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Backup from a hot standby
Next
From: Timothy Madden
Date:
Subject: Re: Database level encryption