Re: error while autovacuuming

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(at)postgresql(dot)org'
Subject: RE: [GENERAL] 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(at)postgresql(dot)org
Subject: RE: [GENERAL] 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(at)seespotcode(dot)net]
Sent: Thursday, September 09, 2010 1:49 AM
To: Scott Marlowe
Cc: tamanna madaan; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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(dot)madan(at)globallogic(dot)com> 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