Correct way to install psql without full Postgres on macOS?

macos postgresql psql macos-sierra
Vitaly Zdanevich picture Vitaly Zdanevich · Jun 20, 2017 · Viewed 53.6k times · Source

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.

Answer

PPS picture PPS · Apr 6, 2018

You could also use homebrew to install libpq.

brew install libpq

This would give you psql, pg_dump and a whole bunch of other client utilities without installing Postgres.

You then add the installation directory to your path. In my case, the directory location is:

/usr/local/Cellar/libpq/10.3/bin

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
How to put psql on the path when using Postgres.app on OS X?

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/…

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