Hello,
when I login to linux and check the env's I see:
PATH=/usr/local/pgsql/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/postgres/bin:/opt/IBMJava2-14/bin:/opt/IBMJava2-14/jre/bin:/usr/local/pgsql/bin
LD_LIBRARY_PATH=/usr/local/pgsql/lib
However after I successfully start postgresql using
/etc/init.d/postgres start
/etc/init.d/postgres status
I cannot execute the following:
psql testdb
psql: relocation error: psql: undefined symbol: PQgetssl
Then if I execute from the command line:
LD_LIBRARY_PATH=/usr/local/pgsql/lib
export LD_LIBRARY_PATH
PATH=/usr/local/pgsql/bin:$PATH
export PATH
then psql testdb works!
What's going on???
thanks,
Phil