Troubleshooting: DS-Software component encounters PostgreSQL Dump errors


Creation Date: January 07, 2010
Revision Date: January 07, 2010
Product: DS-System, BLM Archiver, DS-Client (Linux - RedHat OS only)

Summary

This is a third-party bug.

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.


PREVNEXT