Postgres, pg_dump version mismatch

Question

What could be the cause of this? See the error below.

pg_dump: server version: 9.6.1; pg_dump version: 9.5.5
pg_dump: aborting because of server version mismatch

However, when I investigate:

peter@Peters-MacBook-Pro:~$ psql --version
psql (PostgreSQL) 9.6.1
peter@Peters-MacBook-Pro:~$ pg_dump --version
pg_dump (PostgreSQL) 9.6.1

The two versions are equal.

Additional commands:

peter@Peters-MacBook-Pro:~$ find / -name pg_dump -type f 2>/dev/null
/Applications/pgAdmin3.app/Contents/SharedSupport/pg_dump
/Applications/Postgres-9.6.1.0-2.app/Contents/Versions/9.6/bin/pg_dump
/Applications/Postgres-9.6.1.0.app/Contents/Versions/9.6/bin/pg_dump
/Applications/Postgres.app/Contents/Versions/9.6/bin/pg_dump

peter@Peters-MacBook-Pro:~$ which postgres
/Applications/Postgres.app/Contents/Versions/latest/bin/postgres

peter@Peters-MacBook-Pro:~$ which pg_dump
/Applications/Postgres.app/Contents/Versions/latest/bin/pg_dump

Possible duplicate of Postgresql 9.2 pg_dump version mismatch — vabada
– vabada, Commented Feb 13, 2017 at 19:31
@vabada I have no /usr/bin/pg_dump folder which seems to be the root issue in the other thread. — Someguywhocodes
– Someguywhocodes, Commented Feb 13, 2017 at 19:46
Did you execute the pg_dump command that resulted in an error yourself on the commandline or was it executed by some other program like pgAdmin? pgAdmin for instance has a binary paths setting that controls which instance it runs. — Eelke
– Eelke, Commented Feb 13, 2017 at 20:09
IOS has a history of leaving old versions of binaries in the path. Try to use the newest version (possibly in the same /bin/ directory as your postgres DBMS server. -->> use an absolute pathname to call the binary. — wildplasser
– wildplasser, Commented Feb 13, 2017 at 22:18
@wildplasser Could you expand on this answer please? I'm not too sure how to go about "trying to newest version". — Someguywhocodes
– Someguywhocodes, Commented Feb 14, 2017 at 15:59

Someguywhocodes · Accepted Answer · 2017-02-14 16:50:57Z

1

To answer was to run:

/Applications/Postgres.app/Contents/Versions/latest/bin/pg_dump db_name > db.out

The path used came from by looking at the result of:

which postgres
>/Applications/Postgres.app/Contents/Versions/latest/bin/postgres

I then was able to run the correct version pg_dump

answered Feb 14, 2017 at 16:50

Someguywhocodes

7815 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres, pg_dump version mismatch

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related