Re: postgresql doesn't start

From: Nicolas Paris <niparisco(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql doesn't start
Date: 2015-10-03 05:13:19
Message-ID: CA+ssMOR8Udeqgx3U-jgCe2dd=daB9MPUFGtA1cPfLPJ4fHg4iA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hogranch(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Madovsky 2015-10-03 11:09:46 Replication with 9.4
Previous Message David G. Johnston 2015-10-03 04:18:09 Re: Shouldn't "WHEN (OLD.* IS DISTINCT FROM NEW.*)" clause be independent from data type?