Re: postgresql doesn't start

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: postgresql doesn't start
Дата
Msg-id 560EFF47.9090008@hogranch.com
обсуждение исходный текст
Ответ на postgresql doesn't start  (Paolo De Michele <paolo@paolodemichele.it>)
Ответы Re: postgresql doesn't start
Список pgsql-general
On 10/2/2015 2:02 PM, Paolo De Michele wrote:
> exec su postgres -c "/usr/lib/postgresql/9.3/bin/postgres -D
> /var/lib/postgresql/9.3/main -c
> config_file=/etc/postgresql/9.3/main/postgresql.conf"
>
> until yesterday there were no problem
> right now I see this in the /var/log/supervisor's directory:
>
> 2015-10-01 21:40:18 UTC HINT:  The file seems accidentally left over,
> but it could not be removed. Please remove the file by hand and try again.
> 2015-10-01 21:40:20 UTC FATAL:  could not remove old lock file
> "postmaster.pid": Permission denied


try...
     ls -la /var/lib/postgresql/9.3/main

The directory . should be owned by the postgres user, and it should have
700, 750, or 770 permissions.   all the files in it should also be owned
by postgres.

also look and see if postgres logged anything in its own system log
files (/var/log/postgresql/9.3  or whatever).



--
john r pierce, recycling bits in santa cruz



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: postgresql doesn't start
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: aggregates, distinct, order by, and case - why won't this work