Setting up Postgresql on Linux

Tom Lane wrote:

> phil campaigne <pcampaigne@charter.net> writes:
>
>
>> 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
>>
>
>
> What are you checking exactly?  If it's not the output of "env" then
> I would say you are looking at the wrong thing.  Possibly you're looking
> at a profile file that neglects to "export LD_LIBRARY_PATH", or some
> such.
>
>
>
>> I cannot execute the following:
>> psql testdb
>> psql: relocation error: psql: undefined symbol: PQgetssl
>>
>
>
> This is clearly picking up an incompatible version of libpq.so
> (specifically, psql was built with SSL support but libpq.so wasn't).
> I'd suggest trying "which psql" and "ldd" on the psql executable
> to figure out exactly what's what.
>
>             regards, tom lane
>
>
>

I'm not sure how to interpret this,

[phil@hardwoodthunder phil]$ which psql
/usr/bin/psql

[phil@hardwoodthunder phil]$ ldd /usr/bin/psql
       libpq.so.3 => /usr/local/pgsql/lib/libpq.so.3 (0x40013000)
       libpam.so.0 => /lib/libpam.so.0 (0x4002f000)
       libssl.so.2 => /lib/libssl.so.2 (0x40037000)
       libcrypto.so.2 => /lib/libcrypto.so.2 (0x40067000)
       libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x4013e000)
       libz.so.1 => /usr/lib/libz.so.1 (0x4019b000)
       libreadline.so.4 => /usr/lib/libreadline.so.4 (0x401a9000)
       libtermcap.so.2 => /lib/libtermcap.so.2 (0x401d6000)
       libcrypt.so.1 => /lib/libcrypt.so.1 (0x401da000)
       libresolv.so.2 => /lib/libresolv.so.2 (0x40207000)
       libnsl.so.1 => /lib/libnsl.so.1 (0x40217000)
       libdl.so.2 => /lib/libdl.so.2 (0x4022b000)
       libm.so.6 => /lib/libm.so.6 (0x4022e000)
       libc.so.6 => /lib/libc.so.6 (0x40250000)
       libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 (0x4036e000)
       libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x4037e000)
       /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

thanks,
Phil