David Stanaway writes:
> It appears that it was due to running out of space.
> Are there any quick tips for receiving notification of critical errors
> such as this, and how much breathing space to leave on the filesystem
> for the database transaction logs.
As you found out for yourself, at least 16 MB are required "ahead of time"
for the transaction log. On occasion, more space will be needed for
temporary sort files and such. If you're really operating at 97% disk
full you're going to have an awful lot of performance problems. Many file
systems are completely losing it at about 85%.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter