From: Stefan Becker <pgsql@yukonho.de>
To: pgsql-sql@postgresql.org
Subject: Re: pg_clog (?) problem with VACUMM
Date: Tue, 27 Nov 2007 23:05:44 +0100
Message-ID: <001d01c83141$a8a41520$f9ec3f60$@de> (raw)
In-Reply-To: <474C78E2.400@fmed.uba.ar>
References: <474C78E2.400@fmed.uba.ar>
Dear Gerardo and Pgsql-List,
>When executing a VACUUM, i have this msg:
>gse_new_version=# VACUUM ;
>ERROR: could not access status of transaction 118
>DETAIL: could not open file "pg_clog/0000": No existe el fichero o el
I had a similar problem. I decided one day to "clean" out
The pg_clog/ directory of the database cluster. These files'
"last modified time Stamps" on many files were quite
old, so I deleted them. This didn't have any consequences for
the data (dumps or indexes etc.) or the operation of
the installation except, as I found out MUCH later found out
- I could no longer vacuum the Database.
I restored the missing files from a backup and everything
was okay again, after a vacuum of the database the
system cleaned out the older pg_log/ files on its own.
I hope you get things fixed!
My best regards,
Stefan Becker
Email: Stefan@yukonho.de
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgsql@yukonho.de
Subject: Re: pg_clog (?) problem with VACUMM
In-Reply-To: <001d01c83141$a8a41520$f9ec3f60$@de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox