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 <nipari...@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 <pie...@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) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
