| From: | Arjen Nienhuis <a(dot)g(dot)nienhuis(at)gmail(dot)com> |
|---|---|
| To: | tamanna madaan <tamanna(dot)madan(at)globallogic(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, Tapin Agarwal <tapin(dot)agarwal(at)globallogic(dot)com> |
| Subject: | Re: postgres patch for autovacuum error in postgres |
| Date: | 2010-09-09 22:32:41 |
| Message-ID: | AANLkTima5Hhkhqvp64GQWJT_ZezUjRj81iPSTYY713O+@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)madan(at)globallogic(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick | 2010-09-09 22:34:02 | Re: Dynamically update NEW columns in plpgsql trigger |
| Previous Message | tamanna madaan | 2010-09-09 21:07:47 | Re: error while autovacuuming |