From: Scott Marlowe <scott.marlowe@gmail.com>
To: Avi Blackmore <support@satshot.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Replicating between different Slony versions?
Date: Wed, 25 Feb 2009 15:48:49 -0700
Message-ID: <dcc563d10902251448o4ddcce87q307205b571c49b4@mail.gmail.com> (raw)
In-Reply-To: <96E0A3B9-4860-4151-BEE2-1B5983D3434F@satshot.com>
References: <96E0A3B9-4860-4151-BEE2-1B5983D3434F@satshot.com>
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.
> I'm following the "dump and restore, then use Slony to replicate"
> procedure, to minimize downtime. The problem is, the new 2.0 version of
> 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? Or would I be better off installing
> 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. :-)
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.
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: scott.marlowe@gmail.com, support@satshot.com
Subject: Re: Replicating between different Slony versions?
In-Reply-To: <dcc563d10902251448o4ddcce87q307205b571c49b4@mail.gmail.com>
* 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