PostgreSQL: command not found

Question

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?

Greg Hewgill · Accepted Answer · 2010-08-25 00:03:03Z

20

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

answered Aug 25, 2010 at 0:03

Greg Hewgill

1.0m192 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ignacio Chiazzo · Accepted Answer · 2016-04-07 00:23:11Z

7

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.

edited Apr 7, 2016 at 0:23

answered Feb 28, 2016 at 16:16

Ignacio Chiazzo

1,13713 silver badges25 bronze badges

Comments

Viktor · Accepted Answer · 2020-03-26 00:07:00Z

5

Try this command:

find / -name psql

edited Mar 26, 2020 at 0:07

Viktor

2,7933 gold badges22 silver badges31 bronze badges

answered Aug 25, 2010 at 0:30

BarsMonster

6,6012 gold badges37 silver badges48 bronze badges

2 Comments

Tian Over a year ago

Thanks BarsMonster. I put the paths /opt/local/bin /opt/local/sbin /opt/local/lib/postgresql84/bin in my ~/.bash_profile, and that fixed it. Still not sure why psql didn't work, when I went straight to /opt/local/lib/postgresql84/bin though...

Milen A. Radev Over a year ago

Probably because current directory is not in your "PATH".

Topera · Accepted Answer · 2010-08-25 00:47:50Z

2

Try

whereis psql

answered Aug 25, 2010 at 0:47

Topera

12.4k15 gold badges71 silver badges105 bronze badges

Collectives™ on Stack Overflow

PostgreSQL: command not found

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related