Heroku not connecting to Heroku Postgres with CLI

Question

As mentioned in the title, I cannot connect to my Heroku Postgres database.

When I run the command to connect, this is the message that is returned.

heroku pg:psql postgresql-metric-xxxxx --app app-name
--> Connecting to postgresql-metric-xxxxx
 !    The local psql command could not be located. For help installing psql, see
 !    https://devcenter.heroku.com/articles/heroku-postgresql#local-setup

However I have already installed PostgreSQL in my system running Windows 10.

Answer 1

Remember to update your PATH environment variable to add the bin directory of your Postgres installation. The directory will be similar to this: C:\Program Files\PostgreSQL<VERSION>\bin. If you forget to update your PATH, commands like heroku pg:psql won’t work.