Re: slony question - Mailing list pgsql-general

From Chris Browne
Subject Re: slony question
Date
Msg-id 60ejducnf8.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to slony question  ("Josh Harrison" <joshques@gmail.com>)
Responses Re: slony question
List pgsql-general
joshques@gmail.com ("Josh Harrison") writes:
> Does slony support postgres major version upgrade ? ie., will it
> replicate between different major versions?

Yes, that's one of the major "use cases" for Slony-I.

Version 1.0 and 1.1 support (loosely) from PostgreSQL 7.3 to 8.1-ish.

Version 1.2 dropped 7.3 support, but supports up to (just about;
there's a patch not in a 1.2 release that is needed for late-breaking
8.3 changes) 8.3.

You may have to be careful about which version of Slony-I you select
if you have a really old PG database.
--
select 'cbbrowne' || '@' || 'acm.org';
http://www3.sympatico.ca/cbbrowne/lisp.html
"What you  said you   want to do  is  roughly  equivalent to   nailing
horseshoes to the tires of your Buick."  -- danceswithcrows@usa.net on
the question "Why can't Linux use Windows Drivers?"

pgsql-general by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: Script to reset all sequence values in the a given DB?
Next
From: "Obe, Regina"
Date:
Subject: Re: Script to reset all sequence values in the a given DB?