Re: Question about servicescript for stopping and starting postgresqlinstance

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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com