7.1.2 temporary file area - Mailing list pgsql-general

From Travis Bauer
Subject 7.1.2 temporary file area
Date
Msg-id 20010613093833.A9628@swell.cs.indiana.edu
Whole thread Raw
Responses Re: 7.1.2 temporary file area  (Peter Eisentraut <peter_e@gmx.net>)
Re: 7.1.2 temporary file area  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm using 7.1.2 on a Solaris machine.  The back end crashed
and now it won't come back up.  The reason is that I have
a disk quota on the machine the server is running on, and that
disk quota is being exceeded.  But I have 9 megs free in the account,
and it has been working fine.

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?

Thanks,

--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: Does PostgreSQL support EXISTS?
Next
From: Bruno Wolff III
Date:
Subject: Re: abs() does not exists..