Re: 7.1.2 temporary file area

Travis Bauer <trbauer(at)indiana(dot)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