Why can't I add PostgreSQL to my path?

Question

After I upgraded to Mavericks, PostgreSQL started playing up, giving this error message whenever I call pg_restore without calling the full path:

pg_restore: command not found

If I specify the full path it works, but that's obvious not optimal:

/Applications/Postgres93.app/Contents/MacOS/bin/pg_restore --verbose --clean --no-acl --no-owner -h localhost -U steven -d db/testivate_development $file_path

To fix this problem, I have tried removing all versions of PostgreSQL (with Homebrew) and then installed Postgres.app. You can confirm this has worked like this:

$ sudo find / -name pg_restore
/Applications/Postgres93.app/Contents/MacOS/bin/pg_restore
find: /dev/fd/3: Not a directory
find: /dev/fd/4: Not a directory

To add PostgreSQL to my path, I've tried adding each of the following lines to ~/.bash_profile, ~/bashrc and ~/.zshrc, restarting after each attempt:

export PATH="/Applications/Postgres.app/Contents/MacOS/bin:$PATH"

...as per the postgresapp.com documentation, and then...

export PATH="/Applications/Postgres93.app/Contents/MacOS/bin:$PATH"

...as per the comments below.

None of this has solved my problem.

Answer 1

Try adding this line to your .bash_profile:

export PATH="/Applications/Postgres93.app/Contents/MacOS/bin:$PATH"

and remove or comment out the previous reference.