Hi All I am planning to upgrade postgres to avoid this autovacuum problem. >From the release notes of postgres-8.1.x it seems this issue has been solved in postgres-8.1.6 and hence upgrading to latest 8.1 release i.e 8.1.21 will solve this issue. But I was just wondering if postgres-8.4 will also be having this fix (as I couldn't find it in release notes of postgres-8.4). I directly wanted to upgrade to postgres-8.4 so as to avoid all the issue that are already fixed and that's why wanted to check if this will also solve issue with autovacuum. Can you please confirm that .. Thanks... Tamanna -----Original Message----- From: tamanna madaan Sent: Thursday, September 09, 2010 7:25 PM To: 'Michael Glaesemann'; 'Scott Marlowe' Cc: 'pgsql-general@xxxxxxxxxxxxxx' Subject: RE: error while autovacuuming Hi All Can I upgrade directly to postgres-8.4 . I think it would also be having the fix for "autovacuum error" which is there in postgres-8.1.6 . But please confirm . Thanks.. Tamanna -----Original Message----- From: tamanna madaan Sent: Thursday, September 09, 2010 2:40 AM To: 'Michael Glaesemann'; Scott Marlowe Cc: pgsql-general@xxxxxxxxxxxxxx Subject: RE: error while autovacuuming Hi All Thanks for your reply . Actually, I have a cluster setup with two nodes in it. I am having postgres-8.1.2 and am using slony-1.1.5 for replication between two nodes in that cluster. Now, If I plan to upgrade both the servers to postgres-8.1.21, I will be doing it one by one . When one system is upgraded to postgres-8.1.21 , other will still be on postgres-8.1.2 until its also upgraded. So I was just wondering if there wont be any issue with replication using slony-1.1.5 from postgres-8.1.2 to postgres-8.1.21 . Second question : Will slony 1.1.5 work with postgres-8.1.21 or I'll have to upgrade slony as well. Is there any compatibility matrix between slony and postgres . where can I find that ?? Please Reply ... Thanks... Tamanna -----Original Message----- From: Michael Glaesemann [mailto:grzm@xxxxxxxxxxxxxxx] Sent: Thursday, September 09, 2010 1:49 AM To: Scott Marlowe Cc: tamanna madaan; pgsql-general@xxxxxxxxxxxxxx Subject: Re: error while autovacuuming On Sep 8, 2010, at 16:15 , Scott Marlowe wrote: > On Wed, Sep 8, 2010 at 1:11 PM, tamanna madaan > <tamanna.madan@xxxxxxxxxxxxxxx> wrote: >> >> >> Hi All >> >> Can a postgres patch for the fix ( provided in postgres-8.1.6 for >> autovacuum error ) be included with the postgres version I am using i.e >> postgres 8.1.2 so that I don't have to upgrade to 8.1.21 ?? >> >> Please reply > > If you look up the docs on diff and patch, you can easily make your > own from the source code. I'm not doing it, wanting to stay on a bug > ridden release by applying a single patch is insane. Not only that, but the to upgrade to 8.1.21 would require less work (and the same downtime) as to apply the patch. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
