Postgresql Error in psql command not found in zsh mac

0
votes

I have installed postgresql on my mac!

  • However when I run the command "psql" it says:
zsh: command not found: psql

  • I have located the location of my psql command (with other all postgres commands + pgadmin) and it is in /Users/Library/PostgreSQL/13/bin

  • when I do echo $PATH I get:

/Library/Frameworks/Python.framework/Versions/3.8/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin
  • Now what do I do to run psql without any error?
1
postgresqlzshpsql
Check PATH. Use which psql to locate it and add/modify PATH. How did you install it? - kometen
@kometen when I run "which psql" it says: "psql not found"... also I installed it through postgresql site with pgadmin. Also I added PATH in my question.. pls check - mgb
Notice that the location of psql is not on the PATH. You will have to modify your path to include it - coagmano
Or symlink the bins into /usr/local/bin - coagmano
Open .zshrc in an editor and the line above you mention. - kometen

1 Answers

1
votes

/Users/Library/PostgreSQL/13/bin is not in your "path"

Easy solution would be to create a symbolic link for psql in /usr/local/bin/:

ln -s /Users/Library/PostgreSQL/13/bin/psql /usr/local/bin/psql

Otherwise you can edit your profile file and extend your path to /Users/Library/PostgreSQL/13/bin