X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 42AF652835 for ; Thu, 16 Jun 2005 09:03:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24299-07 for ; Thu, 16 Jun 2005 12:03:17 +0000 (GMT) Received: from taylori.com (unknown [202.157.185.133]) by svr1.postgresql.org (Postfix) with ESMTP id 13E7752814 for ; Thu, 16 Jun 2005 09:03:14 -0300 (ADT) Received: from PCsnlim [218.208.240.135] by taylori.com with ESMTP (SMTPD32-7.15) id A9F823B700EE; Thu, 16 Jun 2005 20:00:56 +0800 Message-ID: <057c01c5726b$6ae16270$5800a8c0@taylori.com> From: "Lim Swee Nyin" To: Subject: No Space Left On Device Date: Thu, 16 Jun 2005 20:03:32 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0579_01C572AE.78A54460" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.078 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200506/141 X-Sequence-Number: 17896 This is a multi-part message in MIME format. ------=_NextPart_000_0579_01C572AE.78A54460 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =3D update call set personal=3D1 where rowid=3D8735=20 I tried to update/insert several other tables but the more or less the = same message appear.=20 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 ------=_NextPart_000_0579_01C572AE.78A54460 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi There,
 
When I was fine tuning my already = running=20 application, all of the sudden, I couldn't perform any save/edit = operation on my=20 database, with the error such as:
 
ERROR: could not extend relation=20 4273000/17231/926549: No space left on device SQL =3D update call set = personal=3D1=20 where rowid=3D8735
 
I tried to update/insert several other = tables but=20 the more or less the same message appear.
 
I should have more than enough disk = space on my=20 system:
 
$=20 dfspace
/          &= nbsp;       =20 : Disk space: 15775.57 MB of 21868.99 MB available=20 (72.14%)
/stand         &= nbsp;   =20 : Disk space:    34.51 MB of    39.99 MB = available=20 (86.28%)
/home         &n= bsp;    =20 : Disk space: 13258.27 MB of 15000.00 MB available=20 (88.39%)
/tmp         &nb= sp;     =20 : Disk space:  1023.92 MB of  1024.00 MB available=20 (99.99%)
/var/tmp         = ;  =20 : Disk space:  1023.92 MB of  1024.00 MB available=20 (99.99%)
 
where my postgres DB is on "/". and the = strange=20 thing is, the databas have been running fine for about 4 = months.
 
can any one help please?
 
Thanks a lot.
 
Lim
------=_NextPart_000_0579_01C572AE.78A54460--