Re: no space left on device
Aurangzeb M. Agha <ama-list@mltp.com>
From: "Aurangzeb M. Agha" <ama-list@mltp.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, PostgreSQL General List <pgsql-general@postgresql.org>
Date: 2004-01-20T04:48:49Z
Lists: 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