Re: [GENERAL] pg_ctl start error and lock file

2014-04-29 Thread Dev Kumkar
On Tue, Apr 29, 2014 at 6:26 PM, Albe Laurenz wrote:

> Set "unix_socket_directory" (in versions before 9.3) or
> "unix_socket_directories" (from 9.3 on) in postgresql.conf.
>
> Yours,
> Laurenz Albe
>

Fantastic, thanks for this setting.

regards...


Re: [GENERAL] pg_ctl start error and lock file

2014-04-29 Thread Albe Laurenz
Dev Kumkar wrote:
> 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):
> http://compgroups.net/comp.postgresql.general/postgres-start-error/2886274
> 
> Is there any way to control where the lock file can be created?

Set "unix_socket_directory" (in versions before 9.3) or
"unix_socket_directories" (from 9.3 on) in postgresql.conf.

Yours,
Laurenz Albe



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general