Heroku pg: psql --app my-app does not work, command not found

Question

Environment

• Mac OSX Maverick
• Rails 3.2.11
• Ruby 1.9.2p290
• Heroku Tool Kit

From my terminal:

$ heroku pg:psql --app my-app
---> Connecting to HEROKU_POSTGRESQL_CYAN_URL (DATABASE_URL)
sh: psql: command not found     

Answer 1

This means that you do not have a command psqlin your system. Try to which psqlconfirm. If you installed postgres, then this means that its directory is binnot in your $ PATH. If you have not installed postgres yet, install postgres and try again.

Answer 2

Run brew install postgresand it should work.