On Tue, Apr 22, 2008 at 1:00 PM, Mary Ellen Fitzpatrick <mfitzpat@xxxxxx> 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...
