I'm using 8.1 on XP.
Server disk becomes full during running ANALYSE command.
The following lines are in log file
2005-12-06 18:29:10 ERROR: duplicate key violates unique constraint
"pg_statistic_relid_att_index"
2005-12-06 18:30:23 LOG: autovacuum: processing database "postgres"
2005-12-06 18:31:18 ERROR: could not extend relation 1663/74856/2696: No
space left on device
2005-12-06 18:31:18 HINT: Check free disk space.
2005-12-06 18:31:29 WARNING: corrupted pgstat.stat file
2005-12-06 18:32:37 LOG: autovacuum: processing database "template1"
2005-12-06 18:32:39 LOG: could not close temporary statistics file
"global/pgstat.tmp": No space left on device
2005-12-06 18:32:40 LOG: could not close temporary statistics file
"global/pgstat.tmp": No space left on device
2005-12-06 18:33:42 LOG: autovacuum: processing database "template1"
2005-12-06 18:34:42 LOG: autovacuum: processing database "foo"
2005-12-06 18:35:53 LOG: autovacuum: processing database "bar"
2005-12-06 18:37:12 LOG: autovacuum: processing database "postgres"
2005-12-06 18:38:13 LOG: autovacuum: processing database "template1"
etc.
Should I fix something or can I continue to use this cluster normally ?
Andrus.