Heroku pg:info and pg:psql "Not found"

Question

I'm not sure what has happened to my heroku postgres but when I try to access it with command line with pg:info and pg:psql, I get "Not found".

I even clicked on the button on heroku to create a database for my app as well.

How do I debug this? What can I try? I don't mind starting from scratch since it's for testing.

Answer 1

It wants the psql installed and avalibale on the command line on your local machine. On Ubuntu, I ran sudo apt-get install postgresql-client . heroku pg:psql then worked straight away.

Answer 2

Try passing the appname or database name explicitly. The heroku cli tries to infer your application name from the 'heroku' git remote but if it can't find that it just returns the Not Found message.

eg;

heroku pg:info --app appname

Answer 3

If you are one OS X you should install postgres like this :

brew install postgres