How to fix pg_dump version mismatch errors?

by

OS X 10.8 comes with pg_dump version 9.1.4 in the /usr/bin directory, along with psql and other programs that are client-side PostgreSQL tools. It does not mean that PostgreSQL as a server is installed (unless you have OS X Server Edition).
So you don’t have to uninstall PostgreSQL because it’s not installed and it’s better not to remove these postgres client tools in /usr/bin because they belong to the system as shipped by Apple. They just need to be side-stepped.

The package provided by postgres.app comprises both the PostgreSQL server and the client-side tools of the same version as this server. These tools get installed in /Applications/Postgres.app/Contents/MacOS/bin

To use these instead of the 9.1 ones from Apple when you work in a Terminal, postgres.app documentation says to do:

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

and put it in your .profile file.

Once you have done that and you run pg_dump, you should no longer get the error that’s it’s the wrong version, because it would be the one that ships with postgres.app (currently 9.2.2).

I have this setup and it works OK for me.

More Related Contents:

  1. How to thoroughly purge and reinstall postgresql on ubuntu? [closed]
  2. The infamous java.sql.SQLException: No suitable driver found
  3. How do you find the row count for all your tables in Postgres
  4. Convert hex in text representation to decimal number
  5. SQLAlchemy support of Postgres Schemas
  6. Postgresql SQL GROUP BY time interval with arbitrary accuracy (down to milli seconds)
  7. How to increase the max connections in postgres?
  8. Run a PostgreSQL .sql file using command line arguments
  9. Where does PostgreSQL store configuration/conf files?
  10. How to switch databases in psql?
  11. Creating a copy of a database in PostgreSQL
  12. PostgreSQL function returning multiple result sets
  13. docker postgres pgadmin local connection
  14. How to add a new Column in a table after the 2nd or 3rd column in the Table using postgres?
  15. Can’t connect the postgreSQL with psycopg2
  16. Does a Postgres UNIQUE constraint imply an index?
  17. How do you change the character encoding of a postgres database?
  18. Difference between GiST and GIN index
  19. Test for null in function with varying parameters
  20. Dynamically generate columns for crosstab in PostgreSQL
  21. PostgreSQL: Why psql can’t connect to server?
  22. Postgres error on insert – ERROR: invalid byte sequence for encoding “UTF8”: 0x00
  23. Can I use return value of INSERT…RETURNING in another INSERT?
  24. Changing a postgres containers server port in Docker Compose
  25. How do you find the disk size of a Postgres / PostgreSQL table and its indexes
  26. no pg_hba.conf entry for host
  27. PostgreSQL – disabling constraints
  28. PostgreSQL authentication method 10 not supported
  29. Loop on tables with PL/pgSQL in Postgres 9.0+
  30. How to escape question mark (?) character with Spring JpaRepository

Leave a Comment