Re: Question about servicescript for stopping and starting postgresql instance

2018-10-31 Thread Marian Forums
Hi, Postgres was installed through a repo with yum install. I will try to run it with another type. Regards Marian > Op 30 okt. 2018 om 21:56 heeft Adrian Klaver het > volgende geschreven: > >> On 10/30/18 9:27 AM, Marian Forums wrote: >> Hi Adrain, >> Thanks for your reply. > > > How was

Re: Question about servicescript for stopping and starting postgresql instance

2018-10-30 Thread Adrian Klaver
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 het volgende ge

Re: Question about servicescript for stopping and starting postgresql instance

2018-10-30 Thread Adrian Klaver
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/s

Re: Question about servicescript for stopping and starting postgresql instance

2018-10-30 Thread Marian Forums
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/d

Re: Question about servicescript for stopping and starting postgresql instance

2018-10-30 Thread Adrian Klaver
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:

Question about servicescript for stopping and starting postgresql instance

2018-10-30 Thread Marian Forums
Hi, I have a question about creating a service script to start/stop/status postgresql instance ( version 9.6.8) on Red Hat 7. 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 . Stopping and Starting works. However