Re: postgresql doesn't start

On 10/04/2015 02:45 AM, Paolo De Michele wrote:
> Adrian,
>
> thanks a lot
> about your questions
>
> 1. postgresql was installed via apt-get install postgresql -y command

What OS and version?

> 2. in /var/run/postgresql/ there is only one file called 9.3-main.pid
> 3. postgres is not running, I did not find nothing with ps command
> 4. I remove the postmaster.pid file and I tried to run postgresql

Just the postmaster.pid or it and the 9.3-main.pid?

> manually. this is the result:
>
> # /etc/init.d/postgresql start
> * Starting PostgreSQL 9.3 database server
> The PostgreSQL server failed to start. Please check the log output.
> ...fail!

Try:

pg_ctlcluster 9.3 main start

>
> I verified in /var/log/postgresql/ and I've not found nothing

Nothing as no text at all or nothing as no messages that apply?

What does the system log show?

>
>
>
> On 3 October 2015 at 15:19, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> 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(at)gmail(dot)com
> <mailto:niparisco(at)gmail(dot)com>
> <mailto:niparisco(at)gmail(dot)com <mailto: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 <mailto:pierce(at)hogranch(dot)com>
> <mailto:pierce(at)hogranch(dot)com <mailto: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
> <mailto:pgsql-general(at)postgresql(dot)org>
> <mailto:pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com