Re: Question about servicescript for stopping and starting postgresql instance

Adrian Klaver <adrian.klaver@xxxxxxxxxxx> · Tue, 30 Oct 2018 14:11:45 -0700

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

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx