Wednesday, 25 March 2020

pg_dump: aborting because of server version mismatch

Initiating backup using pg_dump keeps on failing with error as below :

 bash-4.1$ pg_dump nexaprod > nexaprod_db_backup.bkp
pg_dump: server version: 9.6.15; pg_dump version: 8.4.18
pg_dump: aborting because of server version mismatch


There are two versions installed. To update pg_dump with the newer version, create a symbolic link.

[root@oracleasm1 bin]# find / -name pg_dump -type f 2>/dev/null
/usr/bin/pg_dump
/usr/pgsql-9.6/bin/pg_dump



[root@oracleasm1 bin]# mv pg_dump pg_dump_old
[root@oracleasm1 bin]# ln -s /usr/pgsql-9.6/bin/pg_dump /usr/bin/pg_dump

This will create the symlink to the newer version.


Note :
/usr/bin/pg_dump command that is used as default.

With the postgresql install you get another binary at /Library/PostgreSQL/<version>/bin/pg_dump


No comments:

Post a Comment