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.
PostgreSQL backup error - missing libpq.so
+6- Apprentice
+23- Vaulter
Are you installing your own agent, or deploying a marketplace image?
# commvault status | grep Version
Version = 11.40.55
# find / -name libpq.so | sort
/opt/commvault/CVCloudAddOns/PostgreSQL/11/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/12/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/13/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/14/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/15/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/16/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/17/lib/libpq.so
Thanks,
Scott
+6- Apprentice
Sorry I got pulled onto another project.
The issue was this: the OS installed on the EC2 as Amazon linux 2. When the postgres agent was added with the commvault API or directly through the console these were available:
# find / -name libpq.so | sort
/opt/commvault/CVCloudAddOns/PostgreSQL/14/lib/libpq.so
/opt/commvault/CVCloudAddOns/PostgreSQL/15/lib/libpq.so
When we changed the OS to Amazon Linux 2023 and it installed again via the API or through the console it creates this:
# find . -name "libpq.so"
./PostgreSQL/15/lib/libpq.so
./PostgreSQL/16/lib/libpq.so
./PostgreSQL/17/lib/libpq.so
Even though 10, 11, 12, 13, 14 exist as folders they are missing libpq.so
Example for 14:
# tree 14
14
├── bin
│ ├── dropdb
│ ├── pg_config
│ ├── pg_controldata
│ ├── pg_ctl
│ ├── pg_dump
│ ├── pg_dumpall
│ ├── pg_restore
│ ├── psql-cent7
│ ├── psql-rhel8
│ └── psql-rhel9
└── lib
├── libpq.so.5-cent7
├── libpq.so.5-rhel8
└── libpq.so.5-rhel9
Readiverse Academy Certifications
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.