I am upgrading my 3 node hadoop cluster to CDH 5.9. I am trying to take the backup of Hive Metastore which uses Postgresql as metastore database type for which I am running command pg_dump -h [name node hostname] -p 7432 -U scm > /tmp/scm_server_db_backup.$(date +%Y%m%d). Upon running this command I am getting error pg_dump: symbol lookup error: pg_dump: undefined symbol: PQconnectdbParams.
I am running the above command through root. Pls help me resolve this issue. Thank you!