Postgres Pro
Downloads
Home   >   mailing lists

pg_ctl start error and lock file - Mailing list pgsql-general

From Dev Kumkar
Subject pg_ctl start error and lock file
Date
Msg-id CALSLE1N4+siy7CwRLOv9C6Encay0tx8X7sE79Oqfz8qt7omqYg@mail.gmail.com
Whole thread Raw
Responses Re: pg_ctl start error and lock file  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view
Faced following issue when trying to start database using pg_ctl:

FATAL:  could not create lock file "/tmp/.s.PGSQL.5432.lock": Permission denied

Accidentally someone cleaned up /tmp and recreated it but without any write permissions to non-root user, if the non-root user write permissions are given to /tmp then it would start without any issues.
 
I was going thru some links and could find following (> 9+ years old thread):

Is there any way to control where the lock file can be created?

Regards...

pgsql-general by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)
Next
From: David Noel
Date:
Subject: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)