How to choose from - Multiple versions of PostgreSql on Ubuntu desktop -

i have version 9.5 installed . creating local backup heroku need version 9.6.1 thats 1 on heroku - otherwise pg__dump fails error.

ubuntu console dump below -

(py27infobot) dhankar@dhankar-vpceb44en:~$ psql --version psql (postgresql) 9.6.2 (py27infobot) dhankar@dhankar-vpceb44en:~$  (py27infobot) dhankar@dhankar-vpceb44en:~$ pg_config --version postgresql 9.6.2 (py27infobot) dhankar@dhankar-vpceb44en:~$  (py27infobot) dhankar@dhankar-vpceb44en:~$ sudo su - postgres postgres@dhankar-vpceb44en:~$  postgres@dhankar-vpceb44en:~$ psql -c 'select version();'                                                      version                                                      -----------------------------------------------------------------------------------------------------------------  postgresql 9.5.6 on x86_64-pc-linux-gnu, compiled gcc (ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit (1 row)  postgres@dhankar-vpceb44en:~$  postgres@dhankar-vpceb44en:~$  

update - suggested --

~$ locate pg_dump /etc/alternatives/pg_dump.1.gz /etc/alternatives/pg_dumpall.1.gz /usr/bin/pg_dump /usr/bin/pg_dumpall /usr/lib/postgresql/9.5/bin/pg_dump /usr/lib/postgresql/9.5/bin/pg_dumpall /usr/share/man/man1/pg_dump.1.gz /usr/share/man/man1/pg_dumpall.1.gz /usr/share/postgresql/9.5/man/man1/pg_dump.1.gz /usr/share/postgresql/9.5/man/man1/pg_dumpall.1.gz 

further update , used pg_lsclusters :~

(py27infobot) dhankar@dhankar-vpceb44en:~$  (py27infobot) dhankar@dhankar-vpceb44en:~$ pg_lsclusters ver cluster port status owner    data directory               log file 9.5 main    5432 online postgres /var/lib/postgresql/9.5/main /var/log       /postgresql/postgresql-9.5-main.log 9.6 main    5433 online postgres /var/lib/postgresql/9.6/main /var/log    /postgresql/postgresql-9.6-main.log 

(py27infobot) dhankar@dhankar-vpceb44en:~$

seems should document solution worked me - edited .conf file 9.6.2 listen on port 5432 -

"config_file=/etc/postgresql/9.6/main/postgresql.conf" 

current status below -

ver cluster port status owner    data directory               log file 9.5 main    5432 down   postgres /var/lib/postgresql/9.5/main /var/log/postgresql/postgresql-9.5-main.log 9.6 main    5432 online postgres /var/lib/postgresql/9.6/main /var/log/postgresql/postgresql-9.6-main.log 

further update :~ issue not resolved - referring educative answer user - erwin brandstetter , https://dba.stackexchange.com/questions/21006/how-to-run-specific-version-8-4-9-1-of-postgresql-pg-command-e-g-pg-dump/21007#21007 . further question - how use $ pg_dump --cluster 9.6/main , heroku cli command :- heroku pg:pull database_url localdb_infobot --app infobot-co-in .

the standalone - $ pg_dump --cluster 9.6/main @ local console results in - another error

as of - temporary solution , resorting db backup , download , local restore -

heroku pg:backups:capture heroku pg:backups:download pg_restore --verbose --clean --no-acl --no-owner -h localhost -u user_name -d database_name latest.dump