Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid - Mailing list pgsql-admin

From Mariel Cherkassky
Subject Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid
Date
Msg-id CA+t6e1k+y+c7H2WS6AqnXSxSpFB56zCw_NzqApqjRwDYkyTryQ@mail.gmail.com
Whole thread Raw
In response to Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid  (Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>)
Responses Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid  (Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>)
List pgsql-admin
The link you mentioned, suppose to be the new service file ? Weird because I got the most updated rpm installed (of 9.6 version).
My OS version is centos 6.

‫בתאריך יום ג׳, 14 במאי 2019 ב-14:29 מאת ‪Juan José Santamaría Flecha‬‏ <‪juanjo.santamaria@gmail.com‬‏>:‬

On Tue, May 14, 2019 at 11:20 AM Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
Hey,
I'm using a machine in aws and when the machine starts all the services are starting including postgresql(v9.6 , centos).  However, when I check the service`s status I see that it is stopped but all the processes are up (ps -ef ) and the postmaster.pid file is exist with the pid of the postmaster. 

The next part of code responsible for starting postgresql in redhat(/etc/init.d/postgresql) :


This seems to be old code, you can find the example of a start/stop script for 9.6 in:

 

It seems that the sleep 2 isnt enough time to start the processes and thats why the service shows that the instance is down while it is up. Does any one faced this type of issue ? I mean, I can increase the sleep , but I dont think that it is the perfect solution in this case.


What CentOS version are you using, wouldn't it be more appropriate to use systemctl anyway?

Regards,

Juan José Santamaría Flecha

pgsql-admin by date:

Previous
From: Juan José Santamaría Flecha
Date:
Subject: Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid
Next
From: Juan José Santamaría Flecha
Date:
Subject: Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid