Description of problem: I upgraded PostgreSQL cartridge 8.4 to 9.2. When trying to backup the database using pg_dump, I got an error: pg_dump: server version: 9.2.4; pg_dump version: 8.4.13 pg_dump: aborting because of server version mismatch Version-Release number of selected component (if applicable): How reproducible: I was not able to reproduce the way, but the current state of the application is wrong. Actual results: > pg_dump --version pg_dump (PostgreSQL) 8.4.13 [a-jpcz.rhcloud.com 522f5b4ce0b8cdbdb50000d4]\> which pg_dump /usr/bin/pg_dump [a-jpcz.rhcloud.com 522f5b4ce0b8cdbdb50000d4]\> pg_dump --version pg_dump (PostgreSQL) 8.4.13 [a-jpcz.rhcloud.com 522f5b4ce0b8cdbdb50000d4]\> echo $PATH /var/lib/openshift/522f5b4ce0b8cdbdb50000d4/php/phplib/pear/pear:/var/lib/openshift/522f5b4ce0b8cdbdb50000d4/haproxy/usr/bin:/var/lib/openshift /522f5b4ce0b8cdbdb50000d4/php/phplib/pear/pear::/bin:/usr/bin:/usr/sbin Expected results: I'm able to run command: /opt/rh/postgresql92/root/usr/bin/pg_dump [a-jpcz.rhcloud.com 522f5b4ce0b8cdbdb50000d4]\> /opt/rh/postgresql92/root/usr/bin/pg_dump --version pg_dump (PostgreSQL) 9.2.4 Additional info: The forum thread: https://www.openshift.com/forums/openshift/postgres-92-backup-using-pgdump-after-upgrade
Using devenv_3853 # rhc create-app php001 php-5.3 postgresql-8.4 # ssh <gear dns> $ pg_dump --version pg_dump (PostgreSQL) 8.4.13 # rhc cartridge remove -a php001 postgresql-8.4 # rhc cartridge add -a php001 postgresql-9.2 # ssh <gear dns> $ pg_dump --version pg_dump (PostgreSQL) 9.2.4 It appears postgresql/env/OPENSHIFT_POSTGRESQL_PATH_ELEMENT may not have been created or populated. Removing the cartridge and re-installing may correct the issue.
verified with devenv_3851
Removing and reinstalling the cartridge DID NOT correct the issue.
Hi Michal, What version are you running your command against? Production, devenv, or some other environment?
Peter, what do you mean? I upgraded the cartridge via web interface, the `pg_dump` command run in ssh console.
Hi Michal, I'm trying to found out what version of the server you are running this against and the client that you are using. We have a public area (what we call PROD) and internal development sandboxes. Can I assume that you are running your stuff against openshift.redhat.com?
Yes, I'm running the stuff against openshift.redhat.com