Re: [GENERAL] Start/stop postgresql with pg_ctl or service without root access on RHEL

2017-01-20 Thread Tom Lane
Jean-Michel Scheiwiler writes: > We plan to use postgresql on RHEL 6. > DBAs won't have root access but they will need to start/stop the databases. > They'll be able to do so with pg_ctl as postgres. > However databases should also start automatically when the server reboots > and so we should use

[GENERAL] Start/stop postgresql with pg_ctl or service without root access on RHEL

2017-01-20 Thread Jean-Michel Scheiwiler
Hello We plan to use postgresql on RHEL 6. DBAs won't have root access but they will need to start/stop the databases. They'll be able to do so with pg_ctl as postgres. However databases should also start automatically when the server reboots and so we should use services (/etc/init.d/postgresql