Re: postgresql doesn't start
От | Adrian Klaver |
---|---|
Тема | Re: postgresql doesn't start |
Дата | |
Msg-id | 560FD5CA.9000707@aklaver.com обсуждение исходный текст |
Ответ на | Re: postgresql doesn't start (Paolo De Michele <paolo@paolodemichele.it>) |
Ответы |
Re: postgresql doesn't start
(Paolo De Michele <paolo@paolodemichele.it>)
|
Список | 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
В списке pgsql-general по дате отправления: