Re: no space left on device - Mailing list pgsql-general

From Aurangzeb M. Agha
Subject Re: no space left on device
Date
Msg-id Pine.LNX.4.58.0401091526440.1331@cinemaspace.berkeley.edu
Whole thread Raw
In response to Re: no space left on device  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, 9 Jan 2004, Tom Lane wrote:

:"scott.marlowe" <scott.marlowe@ihs.com> writes:
:>> [postgres - DB]$ df -m .
:>> Filesystem           1M-blocks      Used Available Use% Mounted on
:>> -                        63328     55308      4803  93% /
:
:> Do you have root access to it?  if so, set the reserved space for root to
:> be 0%, and then try vacuuming.  Vacuuming requires some free space, and
:> since you're pretty much out, it isn't gonna be able to complete.
:
:Look again --- it's showing free space in MB not KB.  He's got 4.8GB
:free.  (Although that might be free-from-root's-point-of-view, rather
:than what an unprivileged user can use ...)

Tom -- You're right here.  This account is running on a virtual server, so
the 4.8GB free is not for this user.

Re i-nodes:

[admin - temp]$ df -i .
Filesystem            Inodes   IUsed   IFree IUse% Mounted on
-                    8241152 1819166 6421986   23% /

However, I did just get word from the ISP that they had some sort of error
log rotation error which was keeping logs from being deleted off the
machine, taking up a lot of space (for this user account).  So the 93% is
aparently not a good representation of the disk usage, as its not for this
specific user account.

Rgs,

Zeb


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting rid of duplicate tables.
Next
From: Alex
Date:
Subject: SQL Exception Relation xxx does not exist