In this article, we will see reason and solution for below error:
pg_dump: error: server version: 15.2; pg_dump version: 13.10 pg_dump: error: aborting because of server version mismatch
pg_dump: server version: 12.3; pg_dump version: 9.2.24 pg_dump: aborting because of server version mismatch
This is due to different pg_dump versions are there in cluster.
1. We can verify the installed pg_dump installed versions using below command:
find / -name pg_dump -type f 2>/dev/null
Output:(Following is the output from Redhat/CentOS/OracleLinux/.. and for Ubuntu path is different)
/usr/bin/pg_dump /usr/pgsql-15/bin/pg_dump
2. Now, create soft link to latest version(15 is latest in my case)
sudo ln -s /usr/pgsql-15/bin/pg_dump /usr/bin/pg_dump --force