Could not find local psql command

Question

I follow the instructions found here. When I try to start $ heroku pg:psqlor $ heroku pg:psql HEROKU POSTGRESQL_BROWN, I get the following error message:

! Could not find local psql command! For help installing psql, see local-postgresql

I can’t find anything useful in the link that it gives me (these are just links to instructions that I already used, but further down the page), and I can not find this error anywhere else.

If I missed everything you need to know in order to answer this question, just let me know. I am new to all this and teach myself when I go.

Answer 1

I had the same error even after installing Postgres locally. But after watching this I saw that "pqsl" was not in PATH, so I then did

PATH=%PATH%;C:\Program Files\PostgreSQL\9.2\bin

who worked for me

Answer 2

Since then I have decided it myself. When I started heroku pg:info, he said that version number is 9.1.8, I was running 9.2 locally

installing 9.1.8 and ensuring that Path points to the appropriate folder solved the problem.

Answer 3

, toolbelt, psql .

, PostgreSQL; toolbelt, psql.

, PostgreSQL, , psql (, PATH ). , PATH, , , PSQL, Heroku. toolbelt, .

, ​​ Heroku API, .

Answer 4

PATH. PATH psql script ( Mac), sql script /Postgres. , . , , :/Library/PostgreSQL/8.4/scripts/runpsql.sh

PATH , : $ PATH = "/Library/PostgreSQL/8.4/bin: $PATH"

.....

, postgres. . , :

$heroku pg: info === HEROKU_POSTGRESQL_RED_URL (DATABASE_URL)

$heroku pg: HEROKU_POSTGRESQL_RED_URL

Answer 5

, !

Answer 6

, Windows, , ..

C:\Progra ~ 1\PostgreSQL\9.4\

"C:\Program Files\PostgreSQL\9.4\data"

Answer 7

: http://www.computerhope.com/issues/ch000549.htm, , PATH.

Answer 8

Windows, PATH Postgresql, heroku pg:psql .

, PATH, bin Postgres. : C:\Program Files\PostgreSQL\<VERSION>\bin. Heroku -:

heroku-postgresql: