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
Comments
Post a Comment