Stop postgreSQL service on Mac via terminal

Question

Running postgreSQL 9.4.5_2 currently

I have tried

pg_ctl stop -W -t 1 -s -D /usr/local/var/postgres -m f

Normally no news is good news but after I will run

pg_ctl status -D /usr/local/var/postgres 

and get pg_ctl: server is running (PID: 536)

I have also tried

pg_ctl restart -w -D /usr/local/var/postgres -c -m i

Response message is:

waiting for server to shut down.......................... failed
pg_ctl: server does not shut down

I've also checked my /Library/LaunchDaemons/ to see why the service is starting at login but no luck so far. Anyone have any ideas on where I should check next? Force quit in the activity monitor also isn't helping me any.

Answer 1

Sadly none of the previous answers help me, it worked for me with:

brew services stop postgresql

Cheers

Answer 2

I tried various options; finally, the below command worked.

sudo -u postgres ./pg_ctl -D /your/data/directory/path stop

example

sudo -u postgres ./pg_ctl -D /Library/PostgreSQL/11/data stop