Re: Can't write lock file - Mailing list pgsql-general

From scott.marlowe
Subject Re: Can't write lock file
Date
Msg-id Pine.LNX.4.33.0210211125220.22490-100000@css120.ihs.com
Whole thread Raw
In response to Re: Can't write lock file  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
On Mon, 21 Oct 2002, Nigel J. Andrews wrote:

>
> On Mon, 21 Oct 2002, MT wrote:
>
> > I have Apache and Postgres set up on a Red Hat 7.1 system. I recently
> > added PHP in order to be able to use phpPgAdmin, and since then
> > postgresql is no longer working. Here's a broad outlineof what I did:
> >
> > rpm -e PHP
> > Downloaded and compiled PHP 4.1.2
> > # ./configure --with-pgsql --with-xml --with-apxs=/etc/httpd/bin/apxs
> > recompiled apache 1.3.24 to use modules
> > restarted apache
> >
> > [edited]
> >
> > /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data/
> > FATAL 1:  Can't write lock file /tmp/.s.PGSQL.5432.lock: No space left
> > on device
> >
> > I read up on this but found no satisfactory solution.
>
> By this you mean that there is space left on the device? How much? It shouldn't
> need too much but then you want a decent amount left for use by other things.

Please note that you have to have free data blocks AND free inodes in the
directory tree.

I had an ext partition that ran out of inodes in the directory tree, and
couldn't write to the mounted partition, even though it was only about 20%
full at the time (lots of small files)

Also, many file systems reserve some small amount for root use only (about
1 to 5%) so your drive may look like this:

Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda8             27886048  27328327    557721  98%   /mnt/28g

And still report being out of room.


pgsql-general by date:

Previous
From: "Raymond Lukas"
Date:
Subject: client side software for windows, where?
Next
From: "Williams, Travis L, NPONS"
Date:
Subject: slow update & index question