| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | tamanna madaan <tamanna(dot)madan(at)globallogic(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: error while autovacuuming |
| Date: | 2010-08-27 18:49:40 |
| Message-ID: | 1282934897-sup-5436@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Excerpts from tamanna madaan's message of vie ago 27 05:51:16 -0400 2010:
> I am using a cluster setup with two nodes in it . postgres version is 8.1.2 and slony 1.1.5 is being used for replication.
> I have autovacuum enabled. But it was giving the following error while vacuuming 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
At the very least, update to 8.1.21. I think this may have been caused
by a bug fixed years ago in 8.1.6.
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sunpeng | 2010-08-27 19:19:56 | are there any documents describe the index mechanic? |
| Previous Message | Alban Hertroys | 2010-08-27 17:27:10 | Re: Is your data okay? |