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@gmx.net   http://funkturm.homeip.net/~peter