Re: pg_ctl start error and lock file

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: pg_ctl start error and lock file
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B17CF4CA5@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на pg_ctl start error and lock file  (Dev Kumkar <devdas.kumkar@gmail.com>)
Ответы Re: pg_ctl start error and lock file  (Dev Kumkar <devdas.kumkar@gmail.com>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: David Noel
Дата:
Сообщение: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)