Re: postgresql doesn't start

hi there,

thanks a lot
so, I'm using docker on ubuntu 14.04
about permissions:

# ls -la /var/lib/postgresql/9.3/main
total 72
drwx------ 28 postgres postgres 4096 Oct 3 12:41 .
drwxr-xr-x 4 postgres postgres 4096 Oct 1 11:59 ..
-rwx------ 1 postgres postgres 4 Mar 21 2015 PG_VERSION
drwx------ 12 postgres postgres 4096 Oct 1 11:59 base
drwx------ 2 postgres postgres 4096 Oct 1 11:59 global
drwx------ 2 postgres postgres 4096 Oct 1 11:59 pg_clog
drwx------ 6 postgres postgres 4096 Oct 1 11:59 pg_multixact
drwx------ 2 postgres postgres 4096 Oct 1 11:59 pg_notify
drwx------ 2 postgres postgres 4096 Mar 21 2015 pg_serial
drwx------ 2 postgres postgres 4096 Mar 21 2015 pg_snapshots
drwx------ 2 postgres postgres 4096 Mar 21 2015 pg_stat
drwx------ 2 postgres postgres 4096 Oct 1 11:59 pg_stat_tmp
drwx------ 2 postgres postgres 4096 Oct 1 11:59 pg_subtrans
drwx------ 2 postgres postgres 4096 Mar 21 2015 pg_tblspc
drwx------ 2 postgres postgres 4096 Mar 21 2015 pg_twophase
drwx------ 4 postgres postgres 4096 Oct 1 12:18 pg_xlog
-rwx------ 1 postgres postgres 133 Oct 1 20:00 postmaster.opts
-rw------- 1 postgres postgres 50 Oct 3 12:41 postmaster.pid

in /var/log/postgresql/ I've a file with 0kb
it is weird
is there a way to recover all dbs without starting the daemon?
because I've another one docker with the same configuration and works fine
(same os, same versione of postgresql)

On 3 October 2015 at 07:13, Nicolas Paris <niparisco(at)gmail(dot)com> wrote:

> ​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
>>
>
>