Re: [GENERAL] postgresql doesn't start

2015-10-04 Thread Adrian Klaver
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 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 comman

Re: [GENERAL] postgresql doesn't start

2015-10-04 Thread Adrian Klaver
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 fi

Re: [GENERAL] postgresql doesn't start

2015-10-04 Thread Paolo De Michele
Adrian, thanks a lot about your questions 1. postgresql was installed via apt-get install postgresql -y command 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

Re: [GENERAL] postgresql doesn't start

2015-10-03 Thread Adrian Klaver
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 po

Re: [GENERAL] postgresql doesn't start

2015-10-03 Thread Paolo De Michele
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 postgres4 Mar 21 2015 PG_VERSION drwx-

Re: [GENERAL] postgresql doesn't start

2015-10-02 Thread Nicolas Paris
​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 : > On 10/2/2015 2:02 PM, Paolo De Michele wrote: > >> exec s

Re: [GENERAL] postgresql doesn't start

2015-10-02 Thread John R Pierce
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: 2

Re: [GENERAL] postgresql doesn't start

2015-10-02 Thread Adrian Klaver
On 10/02/2015 02:02 PM, Paolo De Michele wrote: hi there, I've a big problem with my postgresql installation I've postgresql 9.3 installed on docker; I start it via supervisord I've never had issues with postgresql and I don't touched nothing (no update, no changes) this is my configuration the

Re: [GENERAL] postgresql doesn't start

2015-10-02 Thread John R Pierce
On 10/2/2015 2:02 PM, Paolo De Michele wrote: I've postgresql 9.3 installed on docker docker is a packaging system for linux containers, its not an operating system per se.what OS is your docker container running on? supervisord is a process/daemon manager, its not part of 'postgresql

Re: [GENERAL] postgresql doesn't start

2015-10-02 Thread Tom Lane
Paolo De Michele writes: > 2015-10-01 21:40:20 UTC FATAL: could not remove old lock file > "postmaster.pid": Permission denied Looks like something removed the postmaster's write permission on the data directory itself. regards, tom lane -- Sent via pgsql-general mail

[GENERAL] postgresql doesn't start

2015-10-02 Thread Paolo De Michele
hi there, I've a big problem with my postgresql installation I've postgresql 9.3 installed on docker; I start it via supervisord I've never had issues with postgresql and I don't touched nothing (no update, no changes) this is my configuration there's a file called postgresql.conf in /etc/supervi