Postgres.app

Read about Postrgres.app a few weeks ago and I decided to give it a try for my clean install Mountain Lion, turned out it is indeed the easiest (and fastest) way to get PostgreSQL up and running on Mountain Lion.

But when I tried to run psql:

psql: could not connect to server: No such file or directory
 Is the server running locally and accepting
 connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

You can solve this by running psql -h localhost, but I don’t want to type the host parameter for all the PostgreSQL commands. The solution is to add the following to your .bash_login :

export PATH="/Applications/Postgres.app/Contents/MacOS/bin:$PATH"

Thanks Mattt Thompson and Heroku for creating this wonderful app and I look forward to seeing it up on AppStore.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s