Can't create lock file /tmp/.s.PGSQL.5432.lock - Mailing list pgsql-novice

From Patrice Durosay
Subject Can't create lock file /tmp/.s.PGSQL.5432.lock
Date
Msg-id 3FE1EA94.651D0860@cgm.cnrs-gif.fr
Whole thread Raw
Responses Re: Can't create lock file /tmp/.s.PGSQL.5432.lock
Re: Can't create lock file /tmp/.s.PGSQL.5432.lock
List pgsql-novice
Hi all

Running postgres under RedHat9, I moved the /tmp partition to / and copied the /usr into a much larger one in order to
getmore disk space for programs . Hope I did not loose any file. 

One of the problems is that postgre dont start. I Followed the /etc/init.d/postgresql script. It crashes at the line

  su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl  -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start  "


with message

:FATAL:  Can't create lock file /tmp/.s.PGSQL.5432.lock: Permission denied

and the erroneous one

postmaster successfully started

I can understand that the user postgres:postgres cannot write in the /tmp directorythat belong to root:root (as usual),
butit worked before. 
A precision,  I have no .s.PGSQL.5432 file in the /tmp directory.

srwxrwxrwx    1 postgres postgres        0 Dec 11 14:01 ./.s.PGSQL.543


Have any suggestion so that I can rstart the postmaster ?
Should I reinstall postgresql and is it a great risk ?

Cordially

Patrice Durosay




pgsql-novice by date:

Previous
From: "Mace, Richard"
Date:
Subject: Re:
Next
From: Tom Lane
Date:
Subject: Re: Can't create lock file /tmp/.s.PGSQL.5432.lock