Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Issue while running pg_dump command to take Postgresql backup

Issue while running pg_dump command to take Postgresql backup

New Contributor

Dear All,

 

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!