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) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings