DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=n1EUTW8TRjA1eCFH52VCdXSt1VupYCweTaARrc01r1KPFnTLFTkPUE+TNuSqm1bY/P
	luJGzl4oNODLiBvjBDvo4HBYfjihAA3RdSH7F7gxeiw5eoELn3DhURkxi/zO6kt5BWNb
	UGdT1HlyI6WZvGOtvajk5zk6BXD7eTHW1WiRk=
MIME-Version: 1.0
In-Reply-To: <96E0A3B9-4860-4151-BEE2-1B5983D3434F@satshot.com>
References: <96E0A3B9-4860-4151-BEE2-1B5983D3434F@satshot.com>
Date: Wed, 25 Feb 2009 15:48:49 -0700
Message-ID: <dcc563d10902251448o4ddcce87q307205b571c49b4@mail.gmail.com>
Subject: Re: Replicating between different Slony versions?
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Avi Blackmore <support@satshot.com>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Wed, Feb 25, 2009 at 3:20 PM, Avi Blackmore <support@satshot.com> wrote:
> Hi folks,
>
> I'm working on migrating our database cluster from PostgreSQL 8.1 to 8.3.
> =A0I'm following the "dump and restore, then use Slony to replicate"
> procedure, to minimize downtime. =A0The problem is, the new 2.0 version o=
f
> Slony-I does not support anything prior to 8.3, so I have to install
> different versions of Slony-I.

Not sure that will work.  or if it does if it will work properly.

> My question is, is this even feasible? =A0Or would I be better off instal=
ling
> Slony-I 1.x on my 8.3 cluster, and then upgrading it after the migration?

Ding!  That's what I'd do.

> I ask first because I am extremely skittish about experimenting with a
> production database cluster. =A0:-)

I'd make a backup, restore it to a test server, and start testing.  I
am pretty protective of my production servers as well.  Testing is the
only way to see your problems ahead of time.