On Tue, Apr 22, 2008 at 1:00 PM, Mary Ellen Fitzpatrick <mfitzpat@bu.edu> wrote:
> I ran the pg_resetxlog -n to test and it found the correct values. Ran it
> for real and it worked.
Note that on most unix systems, some percentage of disk storage is
reserved for use by root only. On linux with ext2/3 you can change
this % with the tune2fs command...
tune2fs -m 0 /dev/sdb2
would set the drive mounted from /dev/sdb2 to have 0 reserved % for
root, and may be enough in the future to get you out of this
situation. Be sure to set it back to 1 or 2 % after you've cleaned up
enough so you have the free space again when you need it.
The same thing can be done with quotas...