[ACCEPTED]-psql and pg_dump version mismatch-pg-dump
sudo rm /usr/bin/pg_dump
sudo ln -s /usr/lib/postgresql/9.3/bin/pg_dump /usr/bin/pg_dump
0
If your pg_dump is sym-linked to pg_wrapper, then the best 11 fix is to tell pg_wrapper which version to use.
Append
* * 9.6 localhost:5432 *
to 10 /etc/postgresql-common/user_clusters, (assuming your postmaster is listening 9 on localhost:5432 of course).
This then fixes 8 the problem for all pg_ commands, doesn't involve 7 breaking anything, and scales nicely for 6 future versions which you may wish to install.
See 5 man pg_wrapper and man postgresqlrc for details and other options.
NB This 4 answer is specifically for Debian/Ubuntu, and 3 is most likely applicable when there are 2 two version of pg installed, eg. after an 1 upgrade.
The pgdg60 package suffix leads me to believe 9 these packages are not from the official 8 Ubuntu repository. Try looking into /etc/apt/sources.list or 7 /etc/apt/sources.list.d and see if you have any third party PPA's 6 or repositories specified.
Try getting the 5 Postgresql packages either from your Ubuntu 4 repo (although these may be a bit out-of-date 3 depending on your Ubuntu version), or from 2 the official postgres repo (they provide 1 an apt server for Ubuntu/Debian): https://wiki.postgresql.org/wiki/Apt
More Related questions
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.