Postgres Pro
Downloads
Home   >   mailing lists

Thread: Should I fix something after disk full error

Should I fix something after disk full error

From
"Andrus"
Date:
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.

Re: Should I fix something after disk full error

From
Tom Lane
Date:
"Andrus" <eetasoft@online.ee> writes:
> I'm using 8.1 on XP.
> Server disk becomes full during running ANALYSE command.
> ...
> Should I fix something or can I continue to use this cluster normally ?

Everything should be OK once you clean off some disk space.
Let us know if you see any evidence that it's not.

            regards, tom lane