From: Brad Nicholson <bnichols@ca.afilias.info>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: Renato Oliveira <renato.oliveira@grant.co.uk>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Migrate postgres to newer hardware
Date: Mon, 05 Apr 2010 08:29:57 -0400
Message-ID: <1270470597.19810.2.camel@bnicholson-desktop> (raw)
In-Reply-To: <1270195138.7497.9.camel@deimos>
References: <7965A9DCF12CC14984420BCC37B1608F25AB1AED49@Elzar.grant.co.uk>
<1269959369.15416.5.camel@deimos>
<7965A9DCF12CC14984420BCC37B1608F25AB1AEE48@Elzar.grant.co.uk>
<1269962795.15416.26.camel@deimos>
<7965A9DCF12CC14984420BCC37B1608F25AB1AEF22@Elzar.grant.co.uk>
<1270195138.7497.9.camel@deimos>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bnichols@ca.afilias.info, imartinez@vectorsf.com, renato.oliveira@grant.co.uk
Subject: Re: Migrate postgres to newer hardware
In-Reply-To: <1270470597.19810.2.camel@bnicholson-desktop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox