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
