How to put psql on the path when using Postgres.app on OS X?

macos postgresql psql
Don P picture Don P · Jan 5, 2014 · Viewed 37.3k times · Source

I've installed Postgres93 on my Mac. I can open the application, and "Open psql" through the app which opens up a command line interface with psql.

However, when I type $ which psql nothing is returned. The installation path is /Applications/Postgres93.app. How do I make $ which psql show the correct result?

Mac OS X - Mavericks

PostgreSQL package, I'm not as sure about. I went here and downloaded it - http://postgresapp.com/

Answer

Bert picture Bert · Feb 19, 2016

I just had postgres installed and was not able to run the psql command until I ran the following command in my terminal: 

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

Now the terminal knows where to find postgres when I use the psql command.

Remember to replace the version number '9.5' with your current version.

Related questions

psql: command not found Mac

I installed PostgreSQL via the graphical install on http://www.postgresql.org/download/macosx/ I see it in my applications and also have the psql terminal in my applications. I need psql to work in the regular terminal for another …

Read More
Correct way to install psql without full Postgres on macOS?

Official page do not mention such case. But many users need only psql without a local database (I have it on AWS). Brew do not have psql.

Read More
How can I start PostgreSQL server on Mac OS X?

Final update: I had forgotten to run the initdb command. By running this command ps auxwww | grep postgres I see that postgres is not running > ps auxwww | grep postgres remcat 1789 0.0 0.0 2434892 480 s000 R+ 11:28PM 0:00.00 grep postgres This raises the question: …

Read More