How do I stop (postgres.app) postgres cluster from command line

Question

How do I stop a particular Postgres.app cluster without using the gui.

Instead of gui, I want to use bash/Terminal.app

I should also point out that, Postgres app has a menu like this

So if I do a kill, would the menu show an incorrect state?

You can do this using `pg_ctl`. First, get the `pid` of your cluster using `pg_ctl status -D `, this will give you the `pid` eg. `server is running (PID: 1143)`. Next, kill the process using `pg_ctl kill ABRT 1143`. — isank-a, Mar 11 '18 at 22:08
I figured kill is not the best answer, because Postgres app wouldn't know about it, so it would not show up in the top menu where it shows which clusters are running. — american-ninja-warrior, Mar 11 '18 at 22:11

score 4 · Accepted Answer · answered Mar 14 '18 at 18:55

4

Can be done using pg_ctl

pg_ctl stop -D <path to postgres data dir>

Example

pg_ctl stop -D ~/Postgres/pg96/data

answered Mar 14 '18 at 18:55

isank-a

1 Answers1