pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReplicating between different Slony versions?
3+ messages / 3 participants
[nested] [flat]
* Replicating between different Slony versions?
@ 2009-02-25 22:20 Avi Blackmore <support@satshot.com>
0 siblings, 2 replies; 3+ messages in thread
From: Avi Blackmore @ 2009-02-25 22:20 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Replicating between different Slony versions?
@ 2009-02-25 22:48 Scott Marlowe <scott.marlowe@gmail.com>
parent: Avi Blackmore <support@satshot.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Marlowe @ 2009-02-25 22:48 UTC (permalink / raw)
To: Avi Blackmore <support@satshot.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Replicating between different Slony versions?
@ 2009-02-26 05:11 Ashish Karalkar <ashishka@synechron.com>
parent: Avi Blackmore <support@satshot.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ashish Karalkar @ 2009-02-26 05:11 UTC (permalink / raw)
To: Avi Blackmore <support@satshot.com>; +Cc: pgsql-admin
Avi Blackmore 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.
>
> 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.
>
>
>
>
>
Yes, You should go for Slony-I 1.x, Two different version of slony on
master and slave will not work.
With Regards
--Ashish
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-02-26 05:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-02-25 22:20 Replicating between different Slony versions? Avi Blackmore <support@satshot.com>
2009-02-25 22:48 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-02-26 05:11 ` Ashish Karalkar <ashishka@synechron.com>
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