blocks|key|480332|text|即使在本地安装Postgres之后，我也有相同的错误。但是在看到这之后，我看到"pqsl“不在路上，于是我就这样做了。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|480333|PATH=%25PATH%25;C:\Program+Files\PostgreSQL\9.2\bin|code-block|syntax|javascript|480334|对我来说很管用|480335|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/heroku/heroku/issues/334^0|W|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

I had same error even after installing Postgres locally.
But after seeing <a href="https://github.com/heroku/heroku/issues/334" rel="noreferrer">this</a>
I saw that "pqsl" was not in the PATH so I then did

<pre><code>PATH=%PATH%;C:\Program Files\PostgreSQL\9.2\bin
</code></pre>

which worked for me

blocks|key|2589902|text|从那以后我自己解决了这个问题。当我运行heroku+pg:info时，它说版本号为9.1.8，我在本地运行9.2|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2589903|安装9.1.8并确保路径指向适当的文件夹解决了问题。|2589904|entityMap^0|J|E|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

I have since solved this myself. When I ran <code>heroku pg:info</code> it says the version number is 9.1.8, I was locally running 9.2

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

blocks|key|480389|text|更改路径后，确保重新启动终端！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|480390|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

After you change the path, make sure to restart the terminal!

blocks|key|1800854|text|设定路径。要了解psql脚本的路径(在mac上)，请在应用程序/Postgres安装中从finder中打开shell脚本。这将给你一个提示，它是在哪里安装。它打开了一个窗口，告诉我它位于这里:/Library/PostgreSQL/8.4/script/runpsql.sh|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1800855|然后，通过键入以下命令，从终端窗口设置路径变量：|1800856|$+PATH="/Library/PostgreSQL/8.4/bin:$PATH"|code-block|syntax|javascript|1800857|(取决于您安装PostgreSQL的位置，首先查找您的bin路径，另一个exp:+/usr/local/Cellar/postgresql@9.6/9.6.8/bin)|1800858|或者.|1800859|还可以通过直接从postgres安装文件夹打开shell来连接到shell。然后输入凭证。如果您不知道凭据，下面是如何查找它们：|1800860|$+heroku+pg:info+===+HEROKU_POSTGRESQL_RED_URL+(DATABASE_URL)|1800861|$+heroku+pg:凭据HEROKU_POSTGRESQL_RED_URL|1800862|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Set the PATH. To find out the PATH of your psql script (on mac) open the sql shell script from your finder in Applications/Postgres installation. This will give you a hint as to where it is installed. That opened a window which told me it is located here: /Library/PostgreSQL/8.4/scripts/runpsql.sh

Then, I set the PATH variable from the terminal window by typing:

<pre><code>$ PATH="/Library/PostgreSQL/8.4/bin:$PATH"
</code></pre>

(depends on the location of your PostgreSQL installation, find your bin path first, another exp: /usr/local/Cellar/postgresql@9.6/9.6.8/bin)

OR.....

You can also connect to the shell by opening the shell directly from your postgres installation folder. Then enter the credentials. If you don't know the credentials, here is how to find them out:

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

$ heroku pg:credentials HEROKU_POSTGRESQL_RED_URL

blocks|key|480538|text|顶部的答案对我来说并不奇怪，我的系统不会使用管理员的访问权限通过cmd添加路径(不知道为什么)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|480539|所以请检查这个>+Windows+>环境变量>系统变量|480540|并添加最后一行(您的版本在路径上可能有所不同)|480541|​|480542|📷|atomic|offset|length|480543|480544|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/bfaf31d78d071a692767e7359ee737aa.png|imageAlt^0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@$K|11|L|12|1|13]]|A|$]]|$1|M|3|G|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U|V|-4]]]]

Top answer wouldn't work for me oddly, my system would not add the Path via cmd with administrator access (Not sure why).
So check this &gt; Windows key &gt; environment variables &gt; system variables
And add the last line (your version may differ in the path)
<a href="https://i.stack.imgur.com/qKJQC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qKJQC.png" alt="enter image description here" /></a>

blocks|key|1800720|text|在默认情况下，确保安装了psql一样的工具箱。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1800721|但是，您还需要确保已经安装了本地副本的PostgreSQL；如果没有，工具箱将无法找到本地psql客户端。|offset|length|style|BOLD|1800722|假设已经安装了PostgreSQL的本地副本，请确保可以直接从命令行执行psql+(即确保正确设置路径)。如果命令未执行，请检查路径，如果它确实执行，则查看是否可以通过Heroku控制面板中提供的PSQL连接字符串进行连接。如果可以连接重新安装工具箱，则如果无法连接提供另一个dev数据库，然后再试一次。|1800723|如果仍然存在问题，我建议在确认位于这里的状态页面中没有列出任何API问题后，联系Heroku支持部门进行帮助。|1800724|entityMap|0|LINK|mutability|MUTABLE|url|https://status.heroku.com/^0|0|E|2|0|0|H|2|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@]|9|@$D|Z|E|10|1|11]]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

Make sure you've installed the toolbelt as psql is installed by default.

However you also need to ensure you've installed a local copy of PostgreSQL; if you don't the toolbelt will be unable to find the native psql client. 

Assuming you have installed a local copy of PostgreSQL, make sure you can execute psql from the command line directly (i.e make sure you PATH is set correctly ). If the command does not execute, check your PATH, if it does execute see if you can connect via the PSQL connection string provided in the Heroku control panel. If you can connect reinstall the toolbelt, if you are unable to connect provision another dev database and try again. 

If there are still issues, I would suggest contacting Heroku support for assistance after verifying no API issues are listed on the status page located <a href="https://status.heroku.com/" rel="nofollow">here</a>.

blocks|key|480397|text|如果这个令人讨厌的消息出现在Windows上，我通过添加一个没有空格的path元素来摆脱它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|480398|C:\Progra~1\PostgreSQL\9.4\data|blockquote|480399|而不是|480400|“C：\Program\PostgreSQL\9.4\data”|480401|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|M|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|N|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|O|8|@]|9|@]|A|$]]]|J|$]]

I got rid if this annoying message on Windows by adding a path element without the spaces, i.e. 

<blockquote>
 C:\Progra~1\PostgreSQL\9.4\data
</blockquote>

instead of

<blockquote>
 “C:\Program Files\PostgreSQL\9.4\data”
</blockquote>

blocks|key|1800897|text|我遵循这里的说明：http://www.computerhope.com/issues/ch000549.htm，如果您喜欢点击路径变量的配置，它对我起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1800898|entityMap|0|LINK|mutability|MUTABLE|url|http://www.computerhope.com/issues/ch000549.htm^0|9|1B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I followed the instructions here: <a href="http://www.computerhope.com/issues/ch000549.htm" rel="nofollow noreferrer">http://www.computerhope.com/issues/ch000549.htm</a>, which worked for me if you prefer to go the point-and-click configuration of the PATH variable.

blocks|key|2590016|text|这种类型的错误通常出现在Windows环境中，因为如果安装Postgresql后不更新路径，则heroku+pg:psql命令无法工作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2590017|因此，您需要更新PATH环境变量以添加Postgres安装的bin目录。目录将如下所示：C:\Program+Files\PostgreSQL\<VERSION>\bin。欲了解更多信息，请访问本地安装网站中的Heroku：|2590018|heroku-postgresql:本地设置|2590019|entityMap|0|LINK|mutability|MUTABLE|url|http://devcenter.heroku.com/articles/heroku-postgresql#local-setup^0|1B|E|0|18|15|0|0|M|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|X|8|@]|D|@$9|Y|A|Z|1|10]]|E|$]]|$1|J|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|Q]]]]

This type of error usually appears in the Windows environment, because if you do not update the PATH after installing Postgresql, <code>heroku pg:psql</code> command does not work. 

So you need to update your PATH environment variable to add the bin directory of your Postgres installation. The directory will look like this: 
<code>C:\Program Files\PostgreSQL\&lt;VERSION&gt;\bin</code>. 
For more information, go to the Heroku in Local setup website:

<a href="http://devcenter.heroku.com/articles/heroku-postgresql#local-setup" rel="nofollow noreferrer">heroku-postgresql: Local setup</a>

blocks|key|2590068|text|我也遇到了同样的问题，发现Heroku在默认情况下似乎没有提供最新版本的PostgreSQL。Heroku入门指令上写的|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2590069|heroku加载项:创建heroku-postgresql:业余爱好-dev|blockquote|2590070|由于某种原因，它提供了一个v10数据库(您可以通过单击仪表板的“插件”选项卡中的Heroku来检查该数据库)。我删除了该数据库，并使用--版本标志提供了一个新的数据库：|2590071|heroku外接程序:创建heroku-postgresql:业余爱好-dev-version+11|2590072|至少到目前为止，您可以在以下链接中找到Heroku支持的Postgres的最新版本：https://devcenter.heroku.com/articles/heroku-postgresql#version-support-and-legacy-infrastructure|2590073|我是在2019年年初写这篇文章的，但根据PostgreSQL网站的说法，下一个版本(12)将“暂定”在2019年第三季度，所以如果你在2019年末阅读这篇文章，v12可能会遇到同样的问题。|2590074|entityMap|0|LINK|mutability|MUTABLE|url|https://devcenter.heroku.com/articles/getting-started-with-nodejs#provision-a-database|1|https://devcenter.heroku.com/articles/heroku-postgresql#version-support-and-legacy-infrastructure|2|https://www.postgresql.org/developer/roadmap/^0|1B|8|0|0|0|0|0|16|2P|1|0|K|C|2|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|15|8|@]|9|@]|C|$]]|$1|I|3|J|5|F|7|16|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|17|8|@]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|M|3|N|5|6|7|1B|8|@]|9|@$A|1C|B|1D|1|1E]]|C|$]]|$1|O|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]|Y|$5|R|S|T|C|$U|Z]]]]

I had the same problem and discovered that Heroku doesn't seem to provision the latest version of PostgreSQL by default. Where the <a href="https://devcenter.heroku.com/articles/getting-started-with-nodejs#provision-a-database" rel="nofollow noreferrer">Heroku Getting Started</a> instructions said

<blockquote>
 heroku addons:create heroku-postgresql:hobby-dev
</blockquote>

That provisioned a v10 database for some reason (which you can check by clicking on Heroku Postgres in the Add-ons tab of your dashboard). I deleted that database and provisioned a new database using the --version flag:

<blockquote>
 heroku addons:create heroku-postgresql:hobby-dev --version 11
</blockquote>

As of now, at least, you can find the latest version of Postgres supported by Heroku at this link: <a href="https://devcenter.heroku.com/articles/heroku-postgresql#version-support-and-legacy-infrastructure" rel="nofollow noreferrer">https://devcenter.heroku.com/articles/heroku-postgresql#version-support-and-legacy-infrastructure</a>

I'm writing this in early 2019, but according to the <a href="https://www.postgresql.org/developer/roadmap/" rel="nofollow noreferrer">PostgreSQL website</a> the next version (12) is "tentatively scheduled" for third quarter of 2019 so if you're reading this in late 2019 potentially the same problem will come up for v12 instead

blocks|key|2590097|text|在Mac上，您可以使用以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2590098|export+PATH="/Library/PostgreSQL/12/bin/:$PATH"|code-block|syntax|javascript|2590099|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

On Mac you can use the following:
<pre><code>export PATH=&quot;/Library/PostgreSQL/12/bin/:$PATH&quot;
</code></pre>

blocks|key|2590127|text|--我在Windows上找到的唯一解决方案：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2590128|转到高级系统设置|ordered-list-item|2590129|转到环境变量|2590130|选择Path变量并单击Edit|2590131|添加新行并输入bin目录路径(C:\Program+\PostgreSQL\bin)并单击“确定”|2590132|重新启动终端|2590133|输入psql命令(heroku+pg:psql)|2590134|entityMap^0|0|M|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$]]|$1|I|3|J|5|H|7|Y|8|@]|D|@]|E|$]]|$1|K|3|L|5|H|7|Z|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|10|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|11|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|12|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|T|$]]

The only solution that I found on Windows:
<ol>
<li>go to advanced system settings</li>
<li>go to environment variables</li>
<li>select Path variable and click Edit</li>
<li>add a new line and enter your bin directory path (C:\Program Files\PostgreSQL&lt;version&gt;\bin) and click ok</li>
<li>restart your terminal</li>
<li>enter your psql command (heroku pg:psql)</li>
</ol>

I'm following the instructions found <a href="https://devcenter.heroku.com/articles/heroku-postgresql#provisioning-the-addon" rel="noreferrer">here.</a> 
When I try to run <code>$ heroku pg:psql</code> or <code>$ heroku pg:psql HEROKU POSTGRESQL_BROWN</code> I recieve the following error message:

<blockquote>
 ! The local psql command could not be located ! For help
 installing psql, see <a href="http://devcenter.heroku.com/articles/local-postgresql" rel="noreferrer">local-postgresql</a>
</blockquote>

I can't find anything useful on the link it gives me (it just links to the instructions I was already using, but further down the page) nor can I find this error anywhere else.

If I've missed anything you need to know to answer this, just let me know. I'm rather new to all this and teaching myself as I go.

The local psql command could not be located

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我按照找到的指令运行$ heroku pg:psql或$ heroku pg:psql HEROKU POSTGRESQL_BROWN时，收到以下错误消息：好了！无法找到本地psql命令！有关安装psql的帮助，请参见。我在它提供给我的链接上找不到任何有用的东西(它只是链接到我已经使用过的指令，但在页面的下方)，也找不到其他地方的错误。如果我错过了你需要知道的任何事情来回答这个问题，请告诉我。我对

问无法找到本地psql命令。
EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法找到本地psql命令。EN

回答 12

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法找到本地psql命令。
EN