Re: Question about servicescript for stopping and starting postgresql instance

On 10/30/18 2:09 PM, Marian Forums wrote:
>
>
> Hi,
> Postgres was installed through a repo with yum install.

So did you disable the start/stop scripts that the package installed?

> I will try to run it with another type.
> Regards
> Marian
>
>> Op 30 okt. 2018 om 21:56 heeft Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> het volgende geschreven:
>>
>>> On 10/30/18 9:27 AM, Marian Forums wrote:
>>> Hi Adrain,
>>> Thanks for your reply.
>>
>>
>> How was Postgres installed on this machine?
>>
>> Have you tried the script from the docs?
>>
>>
>>> My script looks like this:
>>
>> I am no systemd expert, still the Type=forking does not seem right to me.
>>
>>> # cat /usr/lib/systemd/system/postgresql-9.6.pg-tstxxx.service
>>> [Unit]
>>> Description=postgresql_pg-tstxxx
>>> After=syslog.target
>>> After=network.target
>>> [Service]
>>> Type=forking
>>> User=postgresql
>>> Group=postgresqlg
>>> Environment=PGDATA=/data/pg-tstxxx/data-01/
>>> # Run ExecStartPre with root-permissions
>>> PermissionsStartOnly=true
>>> ExecStartPre=/bin/chown postgresql:postgresqlgroup /var/run/postgresql
>>> ExecStart=/usr/pgsql-9.6/bin/pg_ctl start -D ${PGDATA}
>>> ExecStop=/usr/pgsql-9.6/bin/pg_ctl stop -D ${PGDATA} -s -m fast
>>> ExecReload=/usr/pgsql-9.6/bin/pg_ctl reload -D ${PGDATA} -s
>>> Restart=on-failure
>>> KillMode=control-group
>>> ExecStop=/bin/kill -SIGTERM $MAINPID
>>> RestartSec=10s
>>> [Install]
>>> WantedBy=multi-user.target
>>> thanks in advance.
>>> regards,
>>> Marian
>>> Op di 30 okt. 2018 om 14:30 schreef Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>:
>>> On 10/30/18 5:09 AM, Marian Forums wrote:
>>> > Hi,
>>> >
>>> > I have a question about creating a service script to
>>> start/stop/status
>>> > postgresql instance ( version 9.6.8) on Red Hat 7.
>>> How did you install Postgres on the machine?
>>> >
>>> > I have read the explanation of how to create such a service
>>> script on
>>> > https://www.postgresql.org/docs/9.6/static/server-start.html .
>>> Did you use the example at the above link or did you write your own?
>>> If you wrote your own can you show it?
>>> >
>>> > Stopping and Starting works.
>>> > However when I stop the service with:
>>> > systemctl stop postgresq.service and than ask for the status with
>>> > systemctl status postgresql.service, the service gets started again.
>>> >
>>> > Is this normal functionality on Red Hat 7?
>>> > I have searched on the Internet ( including the Red Hat site) for a
>>> > parameter to replace this behavior, but did not find anything.
>>> >
>>> > Your help is much appreciated.
>>> > Thanks in advance.
>>> > Regards,
>>> > Marian
>>> -- Adrian Klaver
>>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com