When running pgadmin3 get error loading shared libraries: libpq.so.5

  • 7012044
  • 27-Mar-2013
  • 07-Dec-2014

Environment

NetIQ Identity Manager Roles Based Provisioning Module

Situation

When running the pgadmin3 that comes with postgres convenince installer, get the error "/opt/novell/idm/rbpm/postgresql/pgAdmin3/bin/pgadmin3: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory"

Resolution

For it to run we need to add 2 paths in the LD_LIBRARY_PATH variable. From the shell console type:
export LD_LIBRARY_PATH=/opt/novell/idm/rbpm/postgresql/pgAdmin3/lib/:/opt/novell/idm/rbpm/postgresql/lib/
 
Note that the paths are relative to where RBPM was installed, change the /opt/novell/idm/rbpm to match the location in the system where the issue occurs.
 
When using the default installation values, the integrated installer uses /opt/novell/idm/rbpm as its root install path, while the framework (individual) installers use /opt/novell/idm as its root install path.