Re: Can't create lock file /tmp/.s.PGSQL.5432.lock

Hi

The right on /tmp must be : drwxrwxrwt and owner : root, group : root

Are they ?

Patrice Durosay wrote:

>Hi all
>
>Running postgres under RedHat9, I moved the /tmp partition to / and copied the /usr into a much larger one in order to get more 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), but it 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
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno(dot)leveque(at)net6d(dot)com
http://www.net6d.com