Tian
Tian

Reputation: 672

PostgreSQL: command not found

I installed PostgreSQL via MacPorts. However, going to /opt/local/lib/postgresql84/bin I am unable to execute any of the pg commands. Does anyone know what I am doing wrong?

Upvotes: 6

Views: 37323

Answers (4)

BarsMonster
BarsMonster

Reputation: 6585

Try this command:

find / -name psql

Upvotes: 5

Ignacio Chiazzo
Ignacio Chiazzo

Reputation: 1087

I had installed postgres (Mac,The capitan SO) with the dmg and also I got the same issue. I had to install psql through brew. Try with this :

brew install postgres

This worked for me.

Upvotes: 7

Topera
Topera

Reputation: 12389

Try

whereis psql

Upvotes: 2

Greg Hewgill
Greg Hewgill

Reputation: 994619

When you say "going to", it sounds like you're using the cd command to change to that directory. Something like:

$ cd /opt/local/lib/postgresql84/bin
$ psql
psql: command not found

Normally on Unix systems, the current directory is not part of your executable search path. So either explicitly execute psql from the current directory using ./:

$ cd /opt/local/lib/postgresql84/bin
$ ./psql

or, add the directory to your PATH:

$ export PATH=/opt/local/lib/postgresql84/bin:$PATH
$ psql

Upvotes: 20

Related Questions