Geek asks and answers

2 versions of pg_dump on my OSX Lion

I had Postgres 9.0.x installed with homebrew, but due to the lack of some modules I uninstalled it using:

brew uninstall postgres

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

Now I have a problem - two versions for pg_dump - 9.0.5 and 9.1.3 and 9.0.5 - this is the default version.

Is there a way to install version 9.1.3 as the default version of pg_dump?

+3
source share
3 answers

, , pg_dump PATH, , , PATH, /USR/.

:

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

,

+12

, , , Mac - pg_dump?

9.2, :/Library/PostgreSQL/9.2/bin/pg_dump

/usr/bin

+5

I had the same error.

pg_dump: server version: 9.1.3; pg_dump version: 9.0.4

I just used the homebrew update function and it updated the north version and pg_dump with the latest version in homebrew (9.3 from 9/19/13).

brew upgrade postgresql

I reworked my dump statement and it worked great.

pg_dump -U postgres development > dump.sql

+1
source

More articles:


All Articles