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.leveque@xxxxxxxxx
http://www.net6d.com



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faqs/FAQ.html