Postgres pg_dump version mismatch error [Postgres.app / postgresapp.com]

After a bit of confusion, I realized that after running Postgres.app [postgresapp.com] for a local PostgreSQL instance on OSX, that I was no longer able to run pg_dump for creating a local backup of my database.​

The error I was running into was something like:

pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 
pg_dump: aborting because of server version mismatch

To fix this error, I had to edit my local bash profile (pico ~/.bash_profile) and add the following entries:​

export PG_DUMP="/Applications/Postgres.app/Contents/MacOS/bin/"
PATH=$PG_DUMP:$PATH

The only change you may have to do is fix the path to your Postgres.app installation if you installed it to some place other than your /Applications folder.​

​Hope this helps someone else running into errors trying to utilize pg_dump or other postgres utilities!

Sig Myers4 Comments