Is PostgreSQL in OS X Mavericks?

Question

I knew PostgreSQL was installed on OS X Mountain Lion, and if you want to work with this database engine, you must install the new version and make some changes ( http://nextmarvel.net/blog/2011/09/ brew-install-postgresql-on-os-x-lion /). I did not do this at the time because it was not necessary for me.

Now I have a Mac with OS X Mavericks (clean install), and if I run psql -- version , as you can see in this article ( http://russbrooks.com/2010/11/25/install-postgresql-9- on-os-x ), the terminal tells me that there is no such command.

 ~ » psql --version zsh: correct 'psql' to 'sl' [nyae]? n zsh: command not found: psql 

Is PostgreSQL installed by default when I do a clean install of OS X Mavericks?

If I want to try PostgreSQL on Mavericks, I just need to run brew install postgresql and will it be ok?

Has anyone tried this?

Many thanks.

Answer 1

Yes, it should be safe brew install postgresql if the brew doctor does not indicate a problem.

My preferred approach is to leave OS X intact intact and use Homebrew to install separate versions of everything I would like to work with. I have tried using OS X's built-in features in the past, and things have a way to get confused in a hurry, especially when upgrading OS X.

Answer 2

For anyone looking for guidance on installing and setting up postgres on a new Mavericks installation: http://marcinkubala.wordpress.com/2013/11/11/postgresql-on-os-x-mavericks/

I hope this will be helpful.

Answer 3

You can download various versions of PostgreSQL from Apple .

Answer 4

Also for the development environment, you can use Postgres.app ( http://postgresapp.com/ ):

Postgres.app is a simple native Mac OS X application that runs on the menu bar without the need for installation. Open the application and you have a PostgreSQL server ready and waiting for new connections. Close the application and the server will shut down. [ http://www.postgresql.org/download/macosx/ ]