-bash：pg_dump：找不到命令 [英] -bash: pg_dump: command not found

问题描述

我正在尝试为Rails应用程序在本地提取生产数据库。我的本地postgres版本太低，因此我需要从9.4.1更新到Postgresql 9.6.5。

I'm trying to pull a production database locally for my rails app. My local postgres version was too low so I needed to update to Postgresql 9.6.5 from 9.4.1.

我通过Homebrew这样安装了Postgres 9.6.6：

I installed Postgres 9.6.6 via Homebrew as such:

brew install postgresql@9.6

然后运行：

brew services start postgresql@9.6

但是，当我尝试执行 pg_dump 时，我会得到 -bash： pg_dump：找不到命令。

However, when I try to do pg_dump I get -bash: pg_dump: command not found.

我也尝试过这样更新路径：

I also tried updating my path as such:

export PATH="/usr/local/Cellar/postgresql\@9.6/9.6.6/bin:$PATH"

您知道我需要做什么才能使 pg_dump 工作吗？

Any idea what I need to do to get pg_dump to work?

推荐答案

将其添加到我的〜/ .bash_profile中可以达到目的：

Adding this to my ~/.bash_profile did the trick:

导出PATH=/usr/local/Cellar/postgresql\@9.6/9.6.6/bin：$ PATH

这篇关于-bash：pg_dump：找不到命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！