Hi - we have been backing up RDS postgres exports fine for a long time with version 14
We are upgrading to version 16 but the postgresql agent seems to be missing some library files?
The job error is:
PostgreSQL Database: [~Loading libpq.so library failed. Please check if required libpq.so file exists in Postgres Lib directory~] Data Backup Failed.<br/>Source: aws-cvpxy-lnx-105, Process: PostGresIfind
Looking on our proxy node I can see version 16 & 17 are missing the required file:
$ find / -name "libpq.so*" 2>/dev/null
/opt/commvault/CVCloudAddOns/PostgreSQL/14/lib/libpq.so.5-cent7
/opt/commvault/CVCloudAddOns/PostgreSQL/14/lib/libpq.so.5-rhel9
/opt/commvault/CVCloudAddOns/PostgreSQL/14/lib/libpq.so.5-rhel8
/opt/commvault/CVCloudAddOns/PostgreSQL/14/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/14/lib/libpq.so.5
/opt/commvault/CVCloudAddOns/PostgreSQL/15/lib/libpq.so.5-rhel8
/opt/commvault/CVCloudAddOns/PostgreSQL/15/lib/libpq.so.5-al2023
/opt/commvault/CVCloudAddOns/PostgreSQL/15/lib/libpq.so.5-cent7
/opt/commvault/CVCloudAddOns/PostgreSQL/15/lib/libpq.so.5-rhel9
/opt/commvault/CVCloudAddOns/PostgreSQL/15/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/15/lib/libpq.so.5
/opt/commvault/CVCloudAddOns/PostgreSQL/16/lib/libpq.so.5-rhel9
/opt/commvault/CVCloudAddOns/PostgreSQL/16/lib/libpq.so.5-al2023
/opt/commvault/CVCloudAddOns/PostgreSQL/16/lib/libpq.so.5-rhel8
/opt/commvault/CVCloudAddOns/PostgreSQL/17/lib/libpq.so.5-rhel9
/opt/commvault/CVCloudAddOns/PostgreSQL/17/lib/libpq.so.5-al2023
/opt/commvault/CVCloudAddOns/PostgreSQL/17/lib/libpq.so.5-rhel8
The Postgres Agent is deployed on an EC2 host that is rebuilt weekly using the API so it is running the latest version all the time.
Question
PostgreSQL backup error - missing libpq.so
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

