Derek Main <[EMAIL PROTECTED]> writes:
> [ pg_dump works as root, fails as postgres ]
> I have since found that this is not caused by a space problem since the
> last time I ran the command, only 90% of the disk was used when it
> crashed.
I think you've forgotten a standard Unix behavior: root is allowed to
use up every last block of disk space, but ordinary unprivileged users
aren't. Ordinary processes will typically start getting "out of disk
space" errors at either 90% or 95% full, depending on what your minfree
setting is for the particular filesystem.
Reducing minfree to zero is *not* a good idea, because filesystem
performance goes to hell in a handbasket when you are down to very
small amounts of free space. It's time to buy a bigger disk, or do
some housekeeping to free up space.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
