postgres patch for autovacuum error in postgres

From: "tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "Tapin Agarwal" <tapin(dot)agarwal(at)globallogic(dot)com>
Subject: postgres patch for autovacuum error in postgres
Date: 2010-09-09 20:38:27
Message-ID: 68666423656E1444A011106C4E085F4DDDB07A@ex3-del1.synapse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

I am using postgres-8.1.2 . I am getting the below error while
autovacuuming template0 database :

2010-08-18 18:36:14 UTC LOG: autovacuum: processing database "template0"

2010-08-18 18:36:14 UTC ERROR: could not access status of transaction
3222599682

2010-08-18 18:36:14 UTC DETAIL: could not open file "pg_clog/0C01": No
such file or directory

I got to know that this is because of some bug in postgres and has been
fixed in postgres-8.1.6.

Due to some reason I don't want to upgrade to postgres-8.1.6.

So, could any of you please confirm if there is any postgres patch with
the fix for autovacuum error

, where can I find that patch and can this patch be applied on
postgres-8.1.2 .

Please reply ...

Thanks...

Tamanna

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tamanna madaan 2010-09-09 21:05:29 Re: error while autovacuuming
Previous Message David Fetter 2010-09-09 20:36:00 Re: error while autovacuuming