Re: no space left on device

From: "Aurangzeb M(dot) Agha" <ama-list(at)mltp(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: no space left on device
Date: 2004-01-20 04:48:49
Message-ID: Pine.LNX.4.58.0401091526440.1331@cinemaspace.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 9 Jan 2004, Tom Lane wrote:

:"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex 2004-01-20 05:00:43 SQL Exception Relation xxx does not exist
Previous Message Tom Lane 2004-01-20 02:26:43 Re: Getting rid of duplicate tables.