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:[email protected]] Sent: Thu 7/22/2010 6:54 PM To: tamanna madaan Cc: [email protected] 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 [email protected] End Point Corporation PGP Key: 0x14964AC8
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
