Users are unable to login to the TIBCO Data Virtualization repository using the 'psql' utility
Article ID: KB0072736
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
When users try to login to the TDV repository using the 'psql' utility, they might come across the following error:
---------------------------
/opt/Tibco/TDV_Server/repository/bin/psql: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory
Issue/Introduction
This article will explain the issue that some users may face when trying to login to the TIBCO Data Virtualization repository using the 'psql' utility.
Environment
Linux
Resolution
The error means that the 'psql' utility is searching for the library file 'libpq.so.5' and does not know in which folder to find it. 'psql' uses the environment variable 'LD_LIBRARY_PATH' to determine which folders to search in, and so you will need to set this variable to the correct folder.
The steps to resolve this are below:
The steps to resolve this are below:
(1) Go to the <TDV_INSTALL>/repository/lib folder as shown in the example below.
(2) Check that the file "libpq.so.5" is present here(Location: /opt/TIBCO/TDV_Server_8.x/repository/lib) using the command:
# cd /opt/TIBCO/TDV_Server/repository/lib
(2) Check that the file "libpq.so.5" is present here(Location: /opt/TIBCO/TDV_Server_8.x/repository/lib) using the command:
# ls -ltr
(3) Set the LD_LIBRARY_PATH env. variable to the folder as in the example below.
# echo $LD_LIBRARY_PATH==> if this displays an empty result instead of displaying a path, run:
# export /opt/TIBCO/TDV_Server_8.x/repository/lib
==> if this displays a path, you can use this (it will append to the path) :
# export LD_LIBRARY_PATH= /opt/TIBCO/TDV_Server_8.x/repository/lib:$LD_LIBRARY_PATH
(5) Run the 'psql' command.
Additional Information
i) https://support.quest.com/kb/246194/-error-while-loading-shared-libraries-libpq-so-5-when-running-the-infobright-stop-ksh-script
ii) https://knowledge.informatica.com/s/article/535361?language=en_US
Feedback
Yes
No
Powered by
