Re: postgresql doesn't start - Mailing list pgsql-general

From Nicolas Paris
Subject Re: postgresql doesn't start
Date
Msg-id CA+ssMOR8Udeqgx3U-jgCe2dd=daB9MPUFGtA1cPfLPJ4fHg4iA@mail.gmail.com
Whole thread Raw
In response to Re: postgresql doesn't start  (John R Pierce <pierce@hogranch.com>)
Responses Re: postgresql doesn't start
List pgsql-general
​Are you using docker on centos ? I had problem with centos/docker/postgresql because container size was (maybe still is) limited to 20GB on that specific OS​. Maybe not related, but good to know

2015-10-03 0:03 GMT+02:00 John R Pierce <pierce@hogranch.com>:
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



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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Shouldn't "WHEN (OLD.* IS DISTINCT FROM NEW.*)" clause be independent from data type?
Next
From: Madovsky
Date:
Subject: Replication with 9.4