Re: BUG #3484: Missing pg_clog file / corrupt index

Feng Chen wrote:
> We also have the same exact problem - every 5 to 10 days when the data
> get to some size, PostgreSQL complains about missing pg_clog files, and
> invalid page headers during either vacuum or reindex operations.

What PG version is this?

> 2007-08-13T10:12:15+00:00  ERROR:  could not access status of
> transaction 0
> 2007-08-13T10:12:15+00:00  DETAIL:  could not create file
> "pg_subtrans/0201": File exists

Huh???

--
Alvaro Herrera                          Developer, http://www.PostgreSQL.org/
"Aprende a avergonzarte más ante ti que ante los demás" (Demócrito)