Re: 7.1.2 temporary file area - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: 7.1.2 temporary file area
Date
Msg-id Pine.LNX.4.30.0106131723230.756-100000@peter.localdomain
Whole thread Raw
In response to 7.1.2 temporary file area  (Travis Bauer <trbauer@indiana.edu>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: Unique rows without a key
Next
From: Bruce Momjian
Date:
Subject: Re: Re: Does PostgreSQL support EXISTS?