7.1.2 temporary file area

Travis Bauer <trbauer@indiana.edu>

From: Travis Bauer <trbauer@indiana.edu>
To: pgsql-general@postgresql.org
Date: 2001-06-13T14:38:33Z
Lists: 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
----------------------------------------------------------------