Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about servicescript for stopping and starting postgresql instance - Mailing list pgsql-general

From Marian Forums
Subject Re: Question about servicescript for stopping and starting postgresql instance
Date
Msg-id CAO42mcLceYfdwuoAdFYaxwTQ+xOoD4EUd0q44-od5BoRR0wu1A@mail.gmail.com
Whole thread Raw
In response to Re: Question about servicescript for stopping and starting postgresqlinstance  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Question about servicescript for stopping and starting postgresqlinstance  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Hi Adrain,
Thanks for your reply.
My script looks like this:
# 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>:
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

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Fwd: Log file
Next
From: Scot Kreienkamp
Date:
Subject: Cascading replication with slots