Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have tried https://devcenter.heroku.com/articles/heroku-postgresql#local-setup but

heroku pg:psql

keeps returning "not found" heroku pg:psql app::databaseName returns The local psql command could not be located. I have add the path to the PostgreSQL bin file into my PATH but the error still appears.

We tried heroku pg:psql push <database name> HEROKU_POSTGRESQL_BLUE_URL --app <app name> but we ended up with Fatal password authentication failed for User.

We changed the pg_hba.conf file for the host method to be trust

# Type  Database  User    Address      Method  
# IPv4 local connections:
host    all       all     <address>    trust

But now the error returned is that the user doesn't exist.

share|improve this question
What pgAdmin has to do with all this? –  Milen A. Radev Nov 7 '13 at 8:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.