Maybe you can download the latest version of postgres 8.1 and change
the version number in the source to 8.1.2 and then compile. Would that
solve your problem?
On Thu, Sep 9, 2010 at 10:38 PM, tamanna madaan
<tamanna.madan@globallogic.com> wrote:
> 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