psql: command not found Mac

Question

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 bash script I'm running for an app.

For some reason, when I run

psql

in the Mac terminal, my output is

-bash: psql: command not found

I ran the following in the terminal:

locate psql | grep /bin

and the output was

/Library/PostgreSQL/9.5/bin/psql

I then edited my ~/.bash_profile and added it to the path like so:

export PATH = /Library/PostgreSQL/9.5/bin/psql:$PATH

The only other thing in ~/.bash_profile is SDK man and it's at the bottom of the script as it says it should be. I've tried setting the bath to just the /Library/PostgreSQL/9.5/bin/ as well. I've restarted my terminal also.

How can I get psql to work?

EDIT After adding to .bashrc, this output is returned when I open terminal

-bash: export: `/Library/PostgreSQL/9.5/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin': not a valid identifier

You have got the PATH slightly wrong. You need the PATH to *"the containing directory"*, not the actual executable. Your PATH should be `export PATH=/Library/PostgreSQL/9.5/bin:$PATH` - without the extra `psql` bit in it. And also, you must remove the spaces around the equals sign. — Mark Setchell, Mar 22 '16 at 13:14
@MarkSetchell I've tried that as well and it still returns psql: command not found — user3147424, Mar 22 '16 at 13:27
/Users/name/.sdkman/candidates/grails/current/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin — user3147424, Mar 22 '16 at 13:36
@MarkSetchell I didn't see removing the spaces. That worked - if you want to add the answer I'll mark it as accepted. — user3147424, Mar 22 '16 at 13:42

score 146 · Accepted Answer · edited May 29 '19 at 20:27

146

You have got the PATH slightly wrong. You need the PATH to "the containing directory", not the actual executable itself.

Your PATH should be set like this:

export PATH=/Library/PostgreSQL/9.5/bin:$PATH

without the extra sql part in it. Also, you must remove the spaces around the equals sign.

Keywords: Postgresql, PATH, macOS, OSX, psql

edited May 29 '19 at 20:27

Suragch

428,106
278
1,284
1,317

answered Mar 22 '16 at 14:13

Mark Setchell

169,892
24
238
370

15

just RESTART YOUR TERMINAL, that might be all it is – russiansummer Jan 18 '18 at 00:26
10

Never, never, never forget the `:$PATH` at the end of this command, or it's gonna hit the fan and paralyze the shell :p – benjaminz Feb 07 '18 at 21:06
1

@Luffydude Questions are free. Feel free to ask a new one and we'll try and help. – Mark Setchell Mar 22 '19 at 22:05
Actually didn't realise I needed to install something, now it works, thanks :) – Luffydude Mar 22 '19 at 22:11
3

for Mojave users: export PATH=/usr/local/opt/postgresql@9.5/bin:$PATH – Davide Carpini Oct 02 '19 at 08:19
If you simply want to pin a single version of postgresql and still have the binaries in the default PATH, you can also run `brew link postgresql@9.5 --force`. – Jan Katins Dec 13 '19 at 09:50
if you work with "zsh", make sure you are modifying files with "z" prefix. It cost me an hour =( – Nuzhdin Vladimir Feb 06 '22 at 11:53

score 37 · Answer 2 · answered Mar 03 '17 at 18:11

37

From the Postgres documentation page:

sudo mkdir -p /etc/paths.d && echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp

restart your terminal and you will have it in your path.

answered Mar 03 '17 at 18:11

mishap

7,596
14
58
91

3

The instructions also say "Of course, you could also just edit your .profile file instead." My cli install did not work until I did this on MacOS 10.12 Sierra with Postgres 10 (the sudo command did not work for me): `vi ~/.profile add this line: export PATH=$PATH:/Applications/Postgres.app/Contents/Versions/10/bin .source ~/.profile` – kevin11 Oct 23 '17 at 15:23

score 29 · Answer 3 · edited Feb 12 '22 at 09:01

For me this worked:

Downloading the App: https://postgresapp.com/downloads.html
Running commands to configure $PATH - note though that it didn't work for me. https://postgresapp.com/documentation/cli-tools.html

Manually add it to the .bash_profile or .zshrc document if you are using zsh:

 cd  # to get to your home folder
 open .bash_profile  # to open your bash_profile
 # Or
 open .zshrc  # to open your zshrc

In your bash profile or zshrc add:

 # Postgres
 export PATH=/Applications/Postgres.app/Contents/Versions/latest/bin

Save the file. Restart the terminal. Type 'psql'. Done.

Davide Carpini · Answer 4 · 2020-03-18T10:03:23.270

28

If someone used homebrew with Mojave or later:

export PATH=/usr/local/opt/postgresql@9.5/bin:$PATH

change version if you need!

edited Mar 18 '20 at 10:03

answered May 14 '19 at 13:06

Davide Carpini

1,363
14
14

score 10 · Answer 5 · answered Jul 26 '20 at 11:30

If Postgresql was downloaded from official website. After installation, running these commands helped me resolve the psql issue.

Go to your home directory with cd ~

In your home directory, run ls -a. Edit the .bash_profile file with vim

vi .bash_profile opens the vim editor.

Insert by pressing i on the editor.

Add export PATH=$PATH:/Applications/Postgres.app/Contents/Versions/<Version Number>/bin

The Version Number refers to the version number of the postgresql installed on your local machine. In my case, version 12 was installed, so I inputed

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

Press the esc key and press :wq to exit the editor.

Enter source .bash_profile in your terminal to read and execute the content of a file just passed as an argument in the current shell script.

Run psql

terminal result

In summary:

cd ~
vi .bash_profile
export PATH=$PATH:/Applications/Postgres.app/Contents/Versions/12/bin Take note of the version number
exit vim
source .bash_profile
psql Works

+1, don't understand why all the hustle, why not set things up automatically during the UI installation process — avocado, Jun 16 '21 at 16:13
`vi .zshrc` for modern macos using zsh and at the end `source .zshrc` — Hamza.am.i, Feb 08 '22 at 18:08

score 9 · Answer 6 · answered Oct 26 '19 at 19:34

9

Mojave, Postgres was installed via

brew install https://raw.githubusercontent.com/lembacon/homebrew-core/bede8a46dea462769466f606f86f82511949066f/Formula/postgresql@9.6.rb

How to get psql in your path:

brew link postgresql@9.6 --force

answered Oct 26 '19 at 19:34

Vittorius

175
2
8

score 5 · Answer 7 · answered Mar 22 '16 at 13:14

5

Modify your PATH in .bashrc, not in .bash_profile:

http://www.gnu.org/software/bash/manual/bashref.html#Bash-Startup-Files

answered Mar 22 '16 at 13:14

Julien Lopez

1,669
5
16
24

I have also added to the .bashrc - still returns the same output. – user3147424 Mar 22 '16 at 13:31
Marked up for useful information, though it did not solve my specific problem. Thanks for the help. – user3147424 Mar 22 '16 at 14:27
Yes I didn't spot the extra spaces in your `PATH` line before Mark pointed that out. :-) Glad I could help. – Julien Lopez Mar 22 '16 at 14:42

score 5 · Answer 8 · answered Feb 12 '20 at 08:32

If Postgres was downloaded and installed, running this should fix the issue:

sudo mkdir -p /etc/paths.d &&
echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee 
/etc/paths.d/postgresapp

Restart the terminal and you'll be able to use psql command.

Ref: https://postgresapp.com/documentation/cli-tools.html

score 4 · Answer 9 · edited Jun 20 '20 at 09:12

Open the file .bash_profile in your Home folder. It is a hidden file.

Add this path below to the end export PATH line in you .bash_profile file :/Applications/Postgres.app/Contents/Versions/latest/bin

The symbol : separates the paths.

Example:

If the file contains: export PATH=/usr/bin:/bin:/usr/sbin:/sbin

it will become: export PATH=/usr/bin:/bin:/usr/sbin:/sbin:/Applications/Postgres.app/Contents/Versions/latest/bin

How to show hidden files

In Terminal, paste the following: defaults write com.apple.finder AppleShowAllFiles YES

score 3 · Answer 10 · answered Oct 25 '17 at 05:00

3

ANSWERED ON OCTOBER 2017

run

export PATH=/Library/PostgreSQL/9.5/bin:$PATH

and then restart your terminal.

answered Oct 25 '17 at 05:00

Utkarsh Sharma

163
3
10

score 3 · Answer 11 · edited Sep 05 '19 at 16:51

3

As a postgreSQL newbie I found the os x setup instructions on the postgresql site impenetrable. I got all kinds of errors. Fortunately the uninstaller worked fine.

cd /Library/PostgreSQL/11; open uninstall-postgresql.app/

Then I started over with a brew install followed by this article How to setup PostgreSQL on MacOS

It works fine now.

edited Sep 05 '19 at 16:51

Giulio Caccin

2,696
6
33
52

answered Sep 05 '19 at 15:17

mt_

129
8

score 1 · Answer 12 · answered Jan 05 '22 at 12:25

1

In my case, I have updated my .bash_profile and added Postgres path as shown on some of the answers here but running psql in Terminal still gave me a command not found error.

Had to update .zprofile file and add the Postgres path and it worked!

Steps in Terminal:

nano ~/.zprofile
Add this on the end of PATH: /Library/PostgreSQL/14/bin:${PATH} Note: Mind the version number
Save your changes. Ctrl + o then Ctrl + x
source .zprofile

answered Jan 05 '22 at 12:25

Babad00k

75
1
6

Thank! this is the only solution that worked for me. – Androidz Mar 20 '22 at 06:58

score 0 · Answer 13 · answered Jun 24 '21 at 15:59

I know some others have already mentioned that the path needs to be updated however for me it did not work till I added the path itself in quotations. I an not 100% sure why that happened for me but this is the command that worked for me (on MacOS Terminal)

export PATH="/usr/local/opt/postgresql@9.5/bin:$PATH"

score 0 · Answer 14 · answered Mar 20 '22 at 17:47

0

Your path is not defined correctly. Run this command in your terminal:

echo 'export PATH="$PATH:/Library/PostgreSQL/<your psql version>/bin/"' >> ~/.zshrc

zshrc is for you if you are using MacOS Catalina or a newer version.

answered Mar 20 '22 at 17:47

Husnain Mehmood

53
6

score 0 · Answer 15 · answered May 05 '22 at 09:22

I installed postgresql@13 with Homebrew on Mac, and I followed the given instructions in the zsh terminal after installation.

postgresql@13 is keg-only, which means it was not symlinked into /usr/local,because this is an alternate version of another formula.

If you need to have postgresql@13 first in your PATH, run:
echo 'export PATH="/usr/local/opt/postgresql@13/bin:$PATH"' >> ~/.zshrc

For compilers to find postgresql@13 you may need to set:
export LDFLAGS="-L/usr/local/opt/postgresql@13/lib"
export CPPFLAGS="-I/usr/local/opt/postgresql@13/include"

For pkg-config to find postgresql@13 you may need to set:
export PKG_CONFIG_PATH="/usr/local/opt/postgresql@13/lib/pkgconfig"

To restart postgresql@13 after an upgrade:
brew services restart postgresql@13

Or, if you don't want/need a background service you can just run:
/usr/local/opt/postgresql@13/bin/postgres -D /usr/local/var/postgresql@13

You can check if the path is added by running: open .zshrc
and restart the zsh terminal after: exec zsh -l

psql: command not found Mac

15 Answers15

Example:

How to show hidden files

Linked