Replicating between different Slony versions?

From: Avi Blackmore <support(at)satshot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Replicating between different Slony versions?
Date: 2009-02-25 22:20:14
Message-ID: 96E0A3B9-4860-4151-BEE2-1B5983D3434F@satshot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

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?

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

Thanks,
--
Avi Blackmore
Head Programmer/System Administrator
Agri ImaGIS Technologies, Inc.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-02-25 22:48:49 Re: Replicating between different Slony versions?
Previous Message Vladimir Rusinov 2009-02-25 22:08:47 Re: psqlrc file on RHEL5