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 |