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
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. |