Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

-bash: pg_dump: command not found

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.

I installed Postgres 9.6.6 via Homebrew as such:

brew install [email protected]

Then ran:

brew services start [email protected]

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"

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

like image 768
Tom Hammond Avatar asked Jan 21 '18 00:01

Tom Hammond


2 Answers

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

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

like image 108
Tom Hammond Avatar answered Oct 02 '22 18:10

Tom Hammond


For those who have this issue on Mac even though Postgres path is correctly added on your .bash_profile I found that running pg_dump directly from the Terminal does the job.

Just open your Terminal and type:

pg_dump -U username your_database > db_dump.bak

I tried the ff approach and I got the same error:

sudo su - postgres
pg_dump -U username your_database > db_dump.bak

bash: pg_dump: command not found
like image 40
Babad00k Avatar answered Oct 02 '22 17:10

Babad00k