On Tue, Apr 22, 2008 at 1:00 PM, Mary Ellen Fitzpatrick <[EMAIL PROTECTED]> 
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...

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to