Install postgreSQL 9 on mac, Mavericks OSX 10.9 using homebrew

Update Brew

brew update

Install postgreSQL

brew install postgresql

Init database

initdb /usr/local/var/postgresql

Run postgreSQL

pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start &

Create database

createdb iqbaldb

2 thoughts on “Install postgreSQL 9 on mac, Mavericks OSX 10.9 using homebrew”

Franklin Abodo says:

February 15, 2014 at 3:13 pm

I have found createdb to be absent from my startup volume’s /usr/bin folder on 10.9.1 client version. It existed in 10.8.2.

Finder screenshot

Reply
Franklin Abodo says:

February 15, 2014 at 5:22 pm

I discovered a few minutes later that the homebrew-postgres installation exported some paths but not /usr/local/bin/createdb.

Reply