Yes that would be the standard approach. But the Debian package removes pg_ctl from it normal place and wraps it with a perl script in a way that makes it difficult to work with (it doesn’t accept the same arguments):
https://wiki.debian.org/PostgreSql#pg_ctl_replacement <https://wiki.debian.org/PostgreSql#pg_ctl_replacement> @Mangnus, can you give me an example of how I might use pg_lsclusters and pg_ctlcluster? I’ve tried: pg_ctlcluster 9.4 main start Error: could not exec start -D /var/lib/postgresql/9.4/main -l /var/log/postgresql/postgresql-9.4-main.log -s -o -c config_file="/etc/postgresql/9.4/main/postgresql.conf” -Shawn > On Feb 14, 2017, at 11:52 AM, Magnus Hagander <mag...@hagander.net> wrote: > > On Tue, Feb 14, 2017 at 8:47 PM, Joshua D. Drake <j...@commandprompt.com > <mailto:j...@commandprompt.com>> wrote: > On 02/14/2017 11:43 AM, Shawn Thomas wrote: > pangaea:/var/log# systemctl status postgresql > ● postgresql.service - PostgreSQL RDBMS > Loaded: loaded (/lib/systemd/system/postgresql.service; enabled) > Active: active (exited) since Tue 2017-02-14 10:48:18 PST; 50min ago > Process: 28668 ExecStart=/bin/true (code=exited, status=0/SUCCESS) > Main PID: 28668 (code=exited, status=0/SUCCESS) > CGroup: /system.slice/postgresql.service > > What about if use pg_ctl as the postgres user? That will give you a better > idea. > > You don't want ot be doing that on a systemd system, but try a combination of > pg_lsclusters and pg_ctlcluster. Might be you need to shut it down once that > way before it realizes it's down,and then start it back up. > > > -- > Magnus Hagander > Me: http://www.hagander.net/ <http://www.hagander.net/> > Work: http://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>
