Re: Psql errors

Well, this is sort of interesting. I'm running Solaris 10. The
problem was that I didn't export all of the necessary shared
libraries. What's interesting is that it seems to matter what order
these are in, in the path. If I export LD_LIBRARY_PATH and I put the
library identified as the "libdir" in the arguments for ./configure
first, it works, if I put it at that end it doesn't.

Carol

On Dec 22, 2008, at 11:50 PM, Tom Lane wrote:

> Carol Walter <walterc(at)indiana(dot)edu> writes:
>> I just installed Postgres 8.3.4. I have an instance of 8.2.4 running
>> on the same box. When I start psql I get errors as follows:
>> ...
>> template1=# \l
>> ld.so.1: psql: fatal: relocation error: file /db02/postgres/bin/psql:
>> symbol pg_valid_server_encoding_id: referenced symbol not found
>
> pg_valid_server_encoding_id is exported by the 8.3 version of
> libpq.so,
> but not by 8.2. So the problem here is that your 8.3 psql is binding
> to the wrong version of libpq.so. You didn't say what the platform
> is, but the issue is probably related to the search path used to find
> shared libraries.
>
> It would probably work to just overwrite the 8.2 library with 8.3
> --- it should be backwards compatible. (Better save a backup copy
> in case not, of course.)
>
> regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin