Re: 7.1.2 temporary file area

Travis Bauer writes:

> Here is the error I get (I changed the names of the paths listed):
>
> postmaster successfully started
> DEBUG: database system was shut down at 2001-06-13 09:28:28 EST
> DEBUG: CheckPoint record at (0, 12584784)
> DEBUG: Redo record at (0, 12584784); Undo record at (0, 0); Shutdown TRUE
> DEBUG: NextTransactionId: 2123; NextOid: 45698
> 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. How can I
> tell is to put the files in another temporary directory where I
> have more space?

You can't. This temporary file is the precursor of a transaction log
file, so if your disk is full then you're out of luck anyway. Btw., we're
talking about 16 MB here.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter