I installed PostgreSQL on a computer with Mac OS X using the One click installer. Then I try to access PostgreSQL using the psql command, but it doesn't seem to be available.
I get this message:
psql
-bash: psql: command not found
Do I have to install something more? Or how can I configure PostgreSQL so I can use it on my computer?
Appears "the way" to install the client, if you want to use hombrew, is:
brew install postgresql@15
(you need to specify the version after @) then psql (the client command line) will now be available to you (it also installs a local Postgres server/database, but you don't have to use that if all you want is the client).
Apparently there's also a 'wrapper' to the psql command to make it more "user friendly" also available via homebrew (brew install pgcli) in case interesting. Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.
Another option is to install the libpq homebrew package, but it doesn't get in your PATH.
brew install libpq
So follow the instructions it says after install out to add it to your PATH, or brew link --force libpq or add a symlink.
Locate the psql binary. (In a terminal, run locate psql | grep /bin, and make note of the path. (In my case, it's /opt/local/lib/postgresql90/bin/, as it was installed using MacPorts.)
Then, edit the .bash_profile file in your home folder (e.g. mate -w ~/.bash_profile assuming you've textmate), and add the needed line so it's in your path, e.g.:
export PATH=/opt/local/lib/postgresql90/bin/:$PATH
After having saved the file, read the file (. ~/.bash_profile) or open a new terminal, and type psql.
Install just client with brew:
brew install pgcli
then link it:
brew link --force libpq
as output you will get the path to psql:
If you need to have this software first in your PATH instead consider running:
echo 'export PATH="/usr/local/opt/libpq/bin:$PATH"' >> ~/.zshrc
to find this path again:
brew info libpq
I strongly recommend using Postgres.app from the Heroku team, which is also supported by them!
It has a menubar icon and the menu has a psql item:
You will also find psql included here if you want the same version of that as the server (path may vary by version):
/Applications/Postgres.app/Contents/MacOS/bin
If you want, you can add this path to your startup script to execute psql directly:
PATH=/Applications/Postgres.app/Contents/MacOS/bin:$PATH
CAVEAT! AFAIK, Postgres.app doesn't support connections via Unix sockets (I am not sure what this is...), and supports only TCP/IP connections. So don't panic if you fail to connect there from some other programs.
According to the installation guide after the installation has finished there should be shortcuts for StackBuilder, pgAdmin3 and psql in the Application folder of Postgres:
You will also find additional shortcuts to run pgAdmin, the psql command line interface and to access the PostgreSQL documentation.
If there are such shortcuts check where the psql's one is pointing.
brew install libpq
brew link --force libpq
I followed the below walkthrough and it worked. https://blog.timescale.com/tutorials/how-to-install-psql-on-mac-ubuntu-debian-windows/
I installed PostgresQL with the installer from https://www.postgresql.org/download/ The psql executable was put into /Library/PostgreSQL/14/bin. I added that to my path.
You can also use the EDB Installer, but during the installation choose to install only the Command Line Tools
If you don't want to use brew and installing the whole server is overkill, I found that pgAdmin (the GUI app) provides you with a psql cli. Right click the database and choose PSQL Tool to open up a session.
Kinda similar to @inyourcorner, but i had to double-click on the database... see image: (on mac) (and thanks for leading me there!)... -Click on elephant (postgres) icon in upper toolbar -Double-click on the database to work on -Takes you to terminal with prompt to enter psql commands
To highlight the comment:
/Applications/Postgres.app/Contents/Versions/latest/bin – the folder of psql
