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
----------------------------------------------------------------
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 |