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