How to login into default postgreSQL database from TDV server for specific Linux/Unix environment
Article ID: KB0078350
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.6 and higher |
Description
While logging into " PostgreSQL databse " in linux operating system from TDV installation directory we can get below error for specific " Linux/Unix " operating systems.
Error Message :
=============================================
psql: error in loading shared libraries
bash: cannot open shared object file: No such file or directory
==============================================
On some systems with shared libraries you need to tell the system how to find the newly installed shared libraries. The systems on which this is not necessary include FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, and Solaris.
Environment
Specific Linux/Unix environments
Resolution
The method to set the shared library search path varies between platforms, but the most widely-used method is to set the environment variable LD_LIBRARY_PATH like so: In Bourne shells (sh, ksh, bash, zsh):
Follow below steps to set shared library path to login into " postgresql database " :
1) Go to TDV install directory>>Repository folder
2) Run below command to set shared library path ;
LD_LIBRARY_PATH=<install directory>/repository
export LD_LIBRARY_PATH
3) Now go to TDV install directory>>Repository>>bin and run " psql.sh " command to login into default PostgreSQL database.
Follow below steps to set shared library path to login into " postgresql database " :
1) Go to TDV install directory>>Repository folder
2) Run below command to set shared library path ;
LD_LIBRARY_PATH=<install directory>/repository
export LD_LIBRARY_PATH
3) Now go to TDV install directory>>Repository>>bin and run " psql.sh " command to login into default PostgreSQL database.
Issue/Introduction
This article describes how to set the shared library path in Linux/Unix environment in order to login into PostgreSQL database.
Feedback
Yes
No
Powered by
