Friday, June 17, 2016
pg_dump version mismatch - How to fix in CentOS 7
If you've encountered with this issue:
Then it means that the version on your local pg_dump tool is older that the version of the remote postgresql database.
In my case I had postgresql 9.2 running on CentOS 7 and I was trying to dump database out of remote postgresql 9.4. So the solution was to install 9.4 using postgresql repository instead of centos distro repository. Below you will find instructions that you need to do in order to fix this issue on CentOS.
1. Navigate to this link and choose necessary rpm:
http://yum.postgresql.org/repopackages.php#pg94
2. Install rpm
3. Install 9.4:
4. Find necessary pg_dump location:
5. Run newly installed pg_dump:
That's it :-D
pg_dump: server version: 9.4.7; pg_dump version: 9.2.15
pg_dump: aborting because of server version mismatchThen it means that the version on your local pg_dump tool is older that the version of the remote postgresql database.
In my case I had postgresql 9.2 running on CentOS 7 and I was trying to dump database out of remote postgresql 9.4. So the solution was to install 9.4 using postgresql repository instead of centos distro repository. Below you will find instructions that you need to do in order to fix this issue on CentOS.
1. Navigate to this link and choose necessary rpm:
http://yum.postgresql.org/repopackages.php#pg94
2. Install rpm
sudo rpm -Uvh https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-7-x86_64/pgdg-centos94-9.4-2.noarch.rpm3. Install 9.4:
sudo yum install postgresql944. Find necessary pg_dump location:
find / -name pg_dump -type f 2>/dev/null5. Run newly installed pg_dump:
/usr/pgsql-9.4/bin/pg_dump -h {dbhost} -U {dbuser} {dbname} > {dbname}.sqlThat's it :-D
Labels:
pg_dump,
postgresql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment