Stop postgreSQL service on Mac via terminal

macos postgresql pg launchctl
Andrew M picture Andrew M · Dec 9, 2015 · Viewed 16k times · Source

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

Andrew M picture Andrew M · Dec 9, 2015

Tried sudo and su but no such luck. Just found this gui

https://github.com/MaccaTech/postgresql-mac-preferences

If anyone can help with the terminal commands that would be very much appreciated, but till then the gui will get the job done.

Related questions

Cannot install pg gem in Mavericks with Postgres.app

I am trying to install the pg gem for use with Postgres.app on my local machine. I am running Mavericks. Postgres.app is installed and running fine, but I cannot get the gem to work. I've done the following: …

Read More
How can I start PostgreSQL server on Mac OS X?

Final update: I had forgotten to run the initdb command. By running this command ps auxwww | grep postgres I see that postgres is not running > ps auxwww | grep postgres remcat 1789 0.0 0.0 2434892 480 s000 R+ 11:28PM 0:00.00 grep postgres This raises the question: …

Read More
psql: FATAL: role "postgres" does not exist

I'm a postgres novice. I installed the postgres.app for mac. I was playing around with the psql commands and I accidentally dropped the postgres database. I don't know what was in it. I'm currently working on a tutorial: http://…

Read More