Travis Bauer <trbauer@indiana.edu> writes:
> FATAL 2: ZeroFill([a-path]/xlogtemp.7890) failed:
> Disc quota exceeded : [path-to-executable] Startup proc 7890 exited
> with status 512 - abort
> I believe postgres is creating a large temporary file.
That's not a temp file (at least not in our usual meaning of the term).
It's a WAL segment.
You could change $PGDATA/pg_xlog/ to be a symlink to some directory on a
different disk --- but shut down the postmaster first, and be sure to
copy the existing contents of the directory to the new location.
Current sources (7.2-to-be) also have provisions for relocating real
temp files in a similar fashion --- change the directory they live in
to be a symlink. But that won't help you today.
regards, tom lane