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@xxxxxxxxxxxxxxxxx> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general