- $ brew services start mysql Successfully started ` mysql ` (label: homebrew.mxcl.mysql) Behind the scenes, brew services start is doing everything in the post-install message above. First it runs ln -sfv. Then it runs launchctl load /Library/LaunchAgents/homebrew.mxcl.mysql.plist.
- In Linux, it can be done by /etc/init.d/postgresql-9.2 restart. My OSX is not a server app. I think it it can be done by ALTER USER postgres with password '1234'; postgreQSL prompt but I am not sure if it is the meant way. How can you restart the PostgreSQL server in OSX?
Brew install postgresql Others can download the latest version of PostgreSQL here and follow the installation steps. Once downloaded, to verify you've got PostgreSQL installed, run the following command to check your PostgreSQL version.
I love Homebrew, but sometimes it really gets me down, you know?Especially when I have to deal with launchctl.
launchctl loads and unloads services that start at login. In OS X, theseservices are represented by files ending with .plist (which stands for'property list'). These plists are usually stored in either~/Library/LaunchAgents or /Library/LaunchAgents. You load them (i.e. tellthem to start at login) with launchctl load $PATH_TO_LIST and unload them withlaunchctl unload $PATH_TO_LIST. Loading a plist tells the program itrepresents (e.g. redis) to start at login, while unloading it tells theprogram not to start at login.
This post-install message from Homebrew may look familiar:
Doing all that takes too long, and I can never remember where Homebrew plistsare. Fortunately, Homebrew includes a lovely interface for managing this withoutusing ln, launchctl or knowing where plists are.
brew services
First, install brew services by tapping homebrew/services (one time):
Here's an example usage:
Behind the scenes, brew services start is doing everything in the post-installmessage above. First it runs ln -sfv ... for you. Then it runs launchctl load~/Library/LaunchAgents/homebrew.mxcl.mysql.plist. It Just Works.
Brew Start Postgresql Command
Let's say MySQL's acting funky. We can easily restart it:
Now let's see everything we've loaded:
Note that the list of services includes services you started with launchctlload, not just services you loaded with brew services.
Let's say we uninstalled MySQL and Homebrew didn't remove the plist for somereason (it usually removes it for you). There's a command for you:
Kachow.
Hidden Homebrew commands
Homebrew ships with a whole bunch of commands that don't show up in brew--help. You can see a list of them in the Homebrew git repo. Each fileis named like brew-COMMAND, and you run them with brew command. I recommendbrew beer.
What's next
Homebrew Install Postgres
If you liked this, I recommend reading through Homebrew's Tips andTricks. You can also try out another Homebrew extension forinstalling Mac apps: homebrew-cask.
