Christopher Browne cbbrowne at ca.afilias.info
Wed Nov 17 12:24:04 PST 2010
Vick Khera <vivek at khera.org> writes:
> On Wed, Nov 17, 2010 at 10:58 AM, Jaime Casanova <jaime at 2ndquadrant.com> wrote:
>> now being the case that every one of those versions all use the schema
>> for 8.1 then it seems safe, at least until 8.4... 9.0 will use the
>> same schema? anything to be worried?
>>
>
> 9.0 uses the same schema.  At least I have not observed any errors
> replicating from 8.3 to 9.0 using slony 1.2.21.

There are *NO* differences in the tables used.

Looking at the source tree for 1.2:
http://git.postgresql.org/gitweb?p=slony1-engine.git;a=tree;f=src/backend;h=03c8724fbb6e8574d56d58bdb3be54e4ad113f91;hb=refs/heads/REL_1_2_STABLE

The schema goes in slony1_base.sql.

While there are "version-specific" files  nominally for 7.3, 7.4, 8.0,
and 8.1, you'll find that these files are totally empty.

In contrast, there are material differences between the functions used,
where 7.3, 7.4, 8.0, 8.1, and 8.4 files contain not-huge but still
material bits of code that are loaded in by STORE NODE/UPDATE FUNCTIONS.

9.0 uses the same functions as 8.4, in that case.
-- 
output = ("cbbrowne" "@" "afilias.info")
Christopher Browne
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"


More information about the Slony1-general mailing list