[ACCEPTED]-psql and pg_dump version mismatch-pg-dump

Accepted answer
Score: 17
sudo rm /usr/bin/pg_dump
sudo ln -s /usr/lib/postgresql/9.3/bin/pg_dump /usr/bin/pg_dump


Score: 6

If your pg_dump is sym-linked to pg_wrapper, then the best 11 fix is to tell pg_wrapper which version to use.


*   *   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.

Score: 0

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