Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: Juan José Santamaría Flecha <juanjo(dot)santamaria(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid
Date: 2019-05-14 13:10:54
Message-ID: CA+t6e1k+y+c7H2WS6AqnXSxSpFB56zCw_NzqApqjRwDYkyTryQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)santamaria(at)gmail(dot)com‬‏>:‬

>
> On Tue, May 14, 2019 at 11:20 AM Mariel Cherkassky <
> mariel(dot)cherkassky(at)gmail(dot)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:
>
>
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=contrib/start-scripts/linux;h=a37ac8b9ab6bbd372c207b75410a47f923301fa5;hb=d22ca701a39dfd03cdfa1ca238370d34f4bc4ac4
>
>
>
>>
>> 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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Juan José Santamaría Flecha 2019-05-14 14:33:52 Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid
Previous Message Juan José Santamaría Flecha 2019-05-14 11:29:25 Re: postgresql service started but pid is not saved in /var/run/postgresql/postgresql.pid