2 versions of pg_dump on my OSX Lion

Question

I had Postgres 9.0.x installed with homebrew, but because of lack of some modules I removed it using:

brew uninstall postgres

and installed Postgres 9.1.3 from http://www.enterprisedb.com/downloads/postgres-postgresql-downloads.

Now I've got a problem - 2 different versions on pg_dump - 9.0.5 and 9.1.3 and 9.0.5 is the default version.

Is there any way to set the 9.1.3 version as the default version of pg_dump?

Delete the old version, or rename it, or move it to a directory that it is not in the PATH. — wildplasser, May 17 '12 at 12:15
i did - i moved pg_dump to my home directory (just in case) but now when i type: pg_dump --version in the Terminal i've got: -bash: pg_dump: command not found — Andrey Eremin, May 17 '12 at 12:20

score 17 · Accepted Answer · answered May 17 '12 at 12:33

17

So based on your additional comments, your new version of pg_dump is not in your PATH, all you need to do is to remove the old version, and symlink the new one to any directory in your PATH, for example, /usr/bin.

Like follows:

sudo ln -s /actual/new/pg_dump /usr/bin/pg_dump

Hope this helps

answered May 17 '12 at 12:33

Valentin V

24,971
33
103
152

here is what I did with Homebrew as the upgrade didn't fully work for me. Just change the version number with your postgresql version that Homebrew installed: http://blog.swathik.com/2013/06/pgdump-version-mismatch.html – Peter Oct 15 '13 at 19:55
2

sudo ln -s /Applications/Postgres.app/Contents/Versions/9.5/bin/pg_dump /usr/bin/pg_dump ln: /usr/bin/pg_dump: Operation not permitted – antiqe Feb 15 '18 at 10:38

score 7 · Answer 2 · answered Dec 26 '12 at 02:04

7

Valentin has the right answer, but of course, the question for Mac users is where the heck is pg_dump?

If you have version 9.2, it's: /Library/PostgreSQL/9.2/bin/pg_dump

Just copy this to /usr/bin

answered Dec 26 '12 at 02:04

Henley

21,258
32
119
207

6

if you used homebrew, it's /usr/local/Cellar/postgresql/9.2.2/bin (or whatever your version is) – Danny Feb 07 '13 at 17:54

Paul Pettengill · Answer 3 · 2013-09-20T06:00:09.387

3

I was having the same error essentially.

pg_dump: server version: 9.1.3; pg_dump version: 9.0.4

I just used homebrew's upgrade feature, and it brought both the sever and pg_dump versions up to date with the latest version in homebrew (9.3 as of 9/19/13).

brew upgrade postgresql

I reran my dump statement, and it worked perfectly.

pg_dump -U postgres development > dump.sql

edited Sep 20 '13 at 06:00

answered Sep 20 '13 at 05:47

Paul Pettengill

4,843
1
29
33

2 versions of pg_dump on my OSX Lion

3 Answers3