No Space Left On Device - Mailing list pgsql-admin

From Lim Swee Nyin
Subject No Space Left On Device
Date
Msg-id 057c01c5726b$6ae16270$5800a8c0@taylori.com
Whole thread Raw
Responses Re: No Space Left On Device  (Grega Bremec <gregab@p0f.net>)
List pgsql-admin
hi There,
 
When I was fine tuning my already running application, all of the sudden, I couldn't perform any save/edit operation on my database, with the error such as:
 
ERROR: could not extend relation 4273000/17231/926549: No space left on device SQL = update call set personal=1 where rowid=8735
 
I tried to update/insert several other tables but the more or less the same message appear.
 
I should have more than enough disk space on my system:
 
$ dfspace
/                   : Disk space: 15775.57 MB of 21868.99 MB available (72.14%)
/stand              : Disk space:    34.51 MB of    39.99 MB available (86.28%)
/home               : Disk space: 13258.27 MB of 15000.00 MB available (88.39%)
/tmp                : Disk space:  1023.92 MB of  1024.00 MB available (99.99%)
/var/tmp            : Disk space:  1023.92 MB of  1024.00 MB available (99.99%)
 
where my postgres DB is on "/". and the strange thing is, the databas have been running fine for about 4 months.
 
can any one help please?
 
Thanks a lot.
 
Lim

pgsql-admin by date:

Previous
From: "Hortschitz, Stefan"
Date:
Subject: failed insert into serial-type row
Next
From: Marcos
Date:
Subject: Remote Access