nq7geg
Last Updated: February 25, 2016
·
6.967K
· corysimmons
Cory simmons 700

Clean Postgres on Mac Mavericks

You're probably reading this because you've installed Postgres 20 different ways. It's no wonder, tutorials never work and always leave you hanging so you just move on to the next thing without knowing how to undo what you just did as most of it was command line stuff.

This is almost a straight lift from https://wiki.postgresql.org/wiki/Opinionated_OS_X but I'll try to make it a bit more concise and readable.

Here's the quick and easy way to get Postgres on Mac Mavericks.

  • Remove any "Postgres" Applications you might have installed
  • Run ps auxw | grep postgres to see any Postgres instances that might be going. The thing to really care about is if something is in your LaunchAgents dir. If it is, cd to that directory, run open . and delete the Postgres symlink in that directory.
  • Restart your computer to kill all the other Postgres processes (and they won't restart because we removed them from LaunchAgents)
  • Install Postgres.app (unzip, drag to Applications folder, open it)
  • Open your bash profile (I'm using oh-my-zsh so my profile is located at ~/.zshrc, yours might be at ~/.bash_profile or something) and add export PATH="/Applications/Postgres93.app/Contents/MacOS/bin:$PATH" to the bottom of it
  • In Terminal run source ~/.zshrc (or whatever your bash profile file is)
  • Run psql
  • Boom.
Say Thanks
Respond

4 Responses
Add your response

10847
Emilstolarsky

Why would people do development on their main machine when they can just spin up vagrant with premade buildVagrant.sh files? 5 minutes and bam, you've got yourself a clean environment to work in without polluting your main machine.

over 1 year ago ·
11056
Cory simmons 700

Have a CoderWall on that? :)

over 1 year ago ·
11057
41041169880bec75fbe51de48443cefb

@estolarsky vagrant does not always make sense for large and complex apps. (due to computer resources)

over 1 year ago ·
14773
3dbcefe121d4f903933301b25790f79f

This works fine for getting Postgres installed and running but it doesn't make psql available. For one the latest version of Postgres.app is installed here now: /Applications/Postgres.app and there is no /bin directory that I could find in a quick skim where you can access psql.

over 1 year ago ·