Setting up Postgresql on Linux

Tom Lane wrote:

> phil campaigne <pcampaigne(at)charter(dot)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(at)hardwoodthunder phil]$ which psql
/usr/bin/psql

[phil(at)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