Can't make postgresql load at startup in Mac OS

macos postgresql service postgresql-9.3 launchd
Ha Pham picture Ha Pham · Oct 13, 2014 · Viewed 14.9k times · Source

I have installed postgresql via HomeBrew. It worked but today I find that postgresql server does not run when computer start.

I try to use launchctl to load it again with below command:

$ launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

and I see the message:

/usr/local/Cellar/postgresql/9.3.4/homebrew.mxcl.postgresql.plist: Service is disabled

I do not know how to enable postgresql service. Could anyone show me?

Answer

Parag Bafna picture Parag Bafna · Oct 16, 2014

Use -w option with launchctl. 

$ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

-w Overrides the Disabled key and sets it to false.

Related questions

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
Postgres could not connect to server

After I did brew update and brew upgrade, my postgres got some problem. I tried to uninstall postgres and install again, but it didn't work as well. This is the error message.(I also got this error message when I …

Read More