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