Hi Greg

postgres-8.4.0 and 8.4.2 are completely compatible. Does it also mean that
replication will work fine from postgres-8.4.0 to postgres-8.4.2 means 
from a lower to higher release. Does that holds true for postgres-8.4.4 as well ??

Moreover, in the release notes of 8.4.2 (link below),
its mentioned that "A dump/restore is not required for those running 8.4.X unless you are having
hash index" . Does that mean: if I am not using any hash index , then I can upgrade
to postgres-8.4.2 from postgres-8.4.0 simply without any need of exporting my database schema
and data in it before upgrading postgres and then importing it back after upgrade.

won't it corrupt the data if I upgrade postgres db with my database schema/data in it ?? 

http://www.postgresql.org/docs/8.4/static/release-8-4-2.html

Thanks...
Tamanna


-----Original Message-----
From: Greg Sabino Mullane [mailto:greg at endpoint.com]
Sent: Thu 7/22/2010 6:54 PM
To: tamanna madaan
Cc: slony1-general at lists.slony.info
Subject: Re: [Slony1-general] replication through slony beween the nodes having different versions of postgres
 
> would slony still be able to replicate data from the node
> having postgres-8.4.2 to the node having postgres-8.4.0 .

Yes. 8.4.0 and 8.4.2 are completely compatible: the only thing that will 
change is the postgres binary (plus you will need to REINDEX any 
hash indexes you have, however it's very likely you do not have any).

You really should be upgrading all your nodes to 8.4.4 right away, as 
8.4.4 is the the current latest revision in the 8.4 series. Visit the 
upgrade page for more details on what changed between versions:

http://www.postgresql.org/docs/8.4/static/release-8-4-4.html

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100723/a8a1ccd4/attachment.htm