How to connect to postgresql database using shell script
Why don't you update your PATH and export LD_LIBRARY_PATH permanently, by adding to your .profile these lines:
PATH=/opt/novell/sentinel/3rdparty/postgresql/bin/:$PATHexport LD_LIBRARY_PATH=/opt/novell/sentinel/3rdparty/postgresql/lib/Then use the script to connect DB as simple as following
#!/bin/shpsql --host=127.0.0.1 --port=5432 --dbname=SIEM --username=dbauserAfter you run the script, you will be asked about the password.
If you would like not to enter password every time, you can use the password file .pgpass (see documentation for details), just add to your ~/.pgpass the following line:
127.0.0.1:5432:SIEM:dbauser:your_passwordBe safe, dissallow any access to world or group:
chmod 0600 ~/.pgpass.After this, you can connect to your db by using script above without password prompt.