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