7.1.2 temporary file area

From: Travis Bauer <trbauer(at)indiana(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.1.2 temporary file area
Date: 2001-06-13 14:38:33
Message-ID: 20010613093833.A9628@swell.cs.indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keith G. Murphy 2001-06-13 14:39:47 Re: Text data type doesn't accept newlines?
Previous Message Martín Marqués 2001-06-13 14:38:22 Re: Log files, how to rotate properly