Upgrade fails: "Failed to execute command: pg_dump"

[sajugovind]

Following error occurred during PPA upgrade:

Code: [Select]

[ERROR]: Failed to execute command: pg_dump -h`hostname` -U plesk plesk > /usr/local/ppa/tmp/ppa-upgrade-db-backups/2013-12-11-16-16-46/poa-db-backup.sql
[ERROR]: See update log file /usr/local/ppa/log/ppaupdate.log for details.
The issue is caused by incorrect records in /etc/hosts file. Management Node hostname should resolve to communication IP address.

Check current hostname:

Code: [Select]

[root@ppa ~]# hostname
ppa.test.com
Check IP address which are used for access to Postgres database:

Code: [Select]

[root@ppa ~]cat /var/lib/pgsql/9.0/data/pg_hba.conf | grep plesk | awk {'print $4'}
192.168.0.1
Add the following record at the beginning of file /etc/hosts:

Code: [Select]

192.168.0.1   ppa.test.com