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?

Answer 1

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