2 versions of pg_dump on my OSX Lion

macos postgresql osx-lion version pg-dump
Andrey Eremin picture Andrey Eremin · May 17, 2012 · Viewed 28.1k times · Source

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?

Answer

Valentin V picture Valentin V · May 17, 2012

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

Related questions

Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?

This question may look like a duplicate of: How to uninstall postgresql on my Mac (running Snow Leopard) however, there are two major differences. I'm running Lion and I'm trying to uninstall PostgreSQL 9.0.4. I've looked at the last question and …

Read More
Repairing Postgresql after upgrading to OSX 10.7 Lion

I recently upgraded to OSX 10.7, at which point my rails installation completely borked when trying to connect to the psql server. When I do it from the command line using psql -U postgres it works totally fine, but when I …

Read More
Postgres permission denied on MAC OS X

I was following the ruby on rails tutorial to run with postgres but when I try the "rake db:create" I get the following error: could not connect to server: Permission denied Is the server running locally and accepting connections …

Read More