Troubleshooting: DS-Software component encounters PostgreSQL Dump errors
Summary
It applies to all DS-Software products (DS-System, BLM Archiver, DS-NOC, DS-Client) that are installed on the RedHat Linux Operating System version 5.4 and which use a PostgreSQL server version higher than 8.1.11.
This article explains the steps to be followed if your DS-Software component's Event Log reports the following error:
- "pg_dump: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory"
Details
Upgrading a RedHat 5.1, 5.2, or 5.3 installation to version 5.4 may cause problems with the existing PostgreSQL installation. This is because the upgrade (to RedHat 5.4) will remove the libpq.so.5 and libpq.so.5.2 libraries from the PostgreSQL /usr/lib64 directory.
The PostgreSQL service (daemon) will start after upgrading to RedHat 5.4, however the error will occur when any DS-Software component needs to use the psql or pg_dump functions (all database dumps).
If this error is reported, re-install the corresponding PostgreSQL libraries rpm. For example, if you are using PostgreSQL v.8.4, you would re-run the following package:
- postgresql-libs-8.4.1-1PGDG.rhel5.x86_64.rpm
The information provided in this document is provided "AS IS", without warranty of any kind. ASIGRA Inc. (ASIGRA) disclaims all warranties, either express or implied. In no event shall ASIGRA or its business partners be liable for any damages whatsoever, including direct, indirect, incidental, consequential, loss of business profits or special damages, even if ASIGRA or its business partners have been advised of the possibility of such damages. © Asigra Inc. All Rights Reserved. Confidential.
![]() ![]() |