Correct way to install psql without full Postgres on macOS? [closed]

libpq 11.2
MacOS & zsh or bash

below works

1. install libpq

brew install libpq

2. update PATH

   if use zsh:

   echo 'export PATH="/usr/local/opt/libpq/bin:$PATH"' >> ~/.zshrc
   source ~/.zshrc
   
   # or on M1 MacOS
   echo 'export PATH="/opt/homebrew/opt/libpq/bin:$PATH"' >> ~/.zshrc
   source ~/.zshrc
   

   if use bash:

   echo 'export PATH="/usr/local/opt/libpq/bin:$PATH"' >> ~/.bash_profile
   source ~/.bash_profile
   

If you truly don't need postgresql then you don't even have to alter your path to use libra, just link libpq. The docs say the only reason it isn't is to avoid conflicts with the PostgreSQL package.

brew uninstall postgresql
brew install libpq
brew link --force libpq

Homebrew only really has the postgres formula, and doesn't have any specific formula that only installs the psql tool.

So the "correct way" to get the psql application is indeed to install the postgres formula, and you'll see toward the bottom of the "caveats" section that it doesn't actually run the database, it just puts the files on your system:

$  brew install postgres
==> Downloading https://homebrew.bintray.com/bottles/postgresql-9.6.5.sierra.bottle.tar.gz
######################################################################## 100.0%
==> Pouring postgresql-9.6.5.sierra.bottle.tar.gz
==> /usr/local/Cellar/postgresql/9.6.5/bin/initdb /usr/local/var/postgres
==> Caveats
<snip>
To have launchd start postgresql now and restart at login:
  brew services start postgresql
Or, if you don't want/need a background service you can just run:
  pg_ctl -D /usr/local/var/postgres start
==> Summary
🍺  /usr/local/Cellar/postgresql/9.6.5: 3,269 files, 36.7MB

Now you can use psql to connect to remote Postgres servers, and won't be running a local one, although you could if you really wanted to.

To verify that the local postgres daemon isn't running, check your installed homebrew services:

$ brew services list
Name       Status  User Plist
mysql      stopped      
postgresql stopped      

If you don't have Homebrew Services installed, just

$ brew tap homebrew/services

...and you'll get this functionality. For more information on Homebrew Services, read this excellent blog post that explains how it works.

Install libpq:

 brew install libpq

Then, create a symlink:

sudo ln -s $(brew --prefix)/opt/libpq/bin/psql /usr/local/bin/psql

Hope it helps.

Found so many useful answers here, but a bit outdated since homebrew moved the installation files to /opt/homebrew/Cellar/libpq/15.1. After libpq is installed with brew install libpq you can run below command to see new location

brew link --force libpq

Then you can add it to your zshrc with

echo 'export PATH="/opt/homebrew/Cellar/libpq/15.1/bin:$PATH"' >> ~/.zshrc

Binaries courtesy of EnterpriseDB

I found all of these really unsatisfying, especially if you have to support multiple versions of postgres. A MUCH easier solution is to download the binaries here:

https://www.enterprisedb.com/download-postgresql-binaries

And simply run the executable version of psql that matches the database you're working against without any extra steps.

example:

./path/to/specific/version/bin/psql -c '\x' -c 'SELECT * FROM foo;'

A little late, but really the simpliest way is only to:

brew install libpq

It should, automatically add the libpq binaries (which include psql) in /opt/homebrew/opt/libpq/bin. This path might is not in your PATH environment variable. In my case, my regular terminal (that I do not use) has it but Warp (that I do use) did not. To fix this, the libpq binary path needs to be added to your PATH environment variable. To do so, the following line has to be added to the shell configuration file :

export PATH="/opt/homebrew/opt/libpq/bin:$PATH"

Example for the shell configuration file being .zshrc

echo 'export PATH="/opt/homebrew/opt/libpq/bin:$PATH"' >> ~/.zshrc
source ~/.zshrc

To check it, run : psql