| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Dev Kumkar *EXTERN*" <devdas(dot)kumkar(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_ctl start error and lock file |
| Date: | 2014-04-29 12:56:58 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17CF4CA5@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-04-29 13:46:59 | Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows) |
| Previous Message | David Noel | 2014-04-29 10:43:10 | Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows) |