Re: Can't write lock file

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
Cc: MT <mt(at)open2web(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can't write lock file
Date: 2002-10-21 17:30:22
Message-ID: Pine.LNX.4.33.0210211125220.22490-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond Lukas 2002-10-21 17:55:13 client side software for windows, where?
Previous Message Lamar Owen 2002-10-21 17:23:16 Re: Opening postgres 5432 port