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

On 10/03/2015 05:50 AM, Paolo De Michele wrote:
> 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?


What OS and version are you running? Assuming a Debian/Ubuntu flavor for
now.

How was Postgres installed?

So there is a pid file present in the data directory, how about in the
run directory, /var/run/postgresql?

Is Postgres running? so:

ps ax|grep post

or

pg_ctl status  -D /var/lib/postgresql/9.3/main

If not what happens if you remove the pid and start Postgres manually,
not through supervisor?


> 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@gmail.com
> <mailto:niparisco@gmail.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@hogranch.com
>     <mailto: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 <mailto:pgsql-general@postgresql.org>)
>         To make changes to your subscription:
>         http://www.postgresql.org/mailpref/pgsql-general
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com