Re: LD_LIBRARY_PATH not honored on Debian unstable

Markus Schiltknecht wrote:
> Hi,
>
> I'm trying to run 'make check' on a 64bit Debian unstable. That aborts 
> after 60 seconds due to not being able to connect to the postmaster.
>
> I figured that there's nothing wrong with the postmaster, rather psql 
> can't start up, because it gets linked against an older libpq.so.5. It 
> looks like for some reason, it doesn't respect the LD_LIBRARY_PATH env 
> variable, see ldd output:
>
> markus@argodan:/home/markus/projects/pgsql/sources/current/pgsql/src/test/regress# 
> LD_LIBRARY_PATH=/home/markus/projects/pgsql/sources/current/pgsql/src/test/regress/./tmp_check/install//usr/lib 
> ldd -r -v tmp_check/install/usr/bin/psql
>
[snip]
> undefined symbol: pg_valid_server_encoding_id 
> (tmp_check/install/usr/bin/psql)
> undefined symbol: PQconnectionNeedsPassword    
> (tmp_check/install/usr/bin/psql)
>
>
> Giving it an additional LD_PRELOAD for the newish libpq.5.1 helps:
>
> markus@argodan:/home/markus/projects/pgsql/sources/current/pgsql/src/test/regress# 
>
> LD_PRELOAD=/home/markus/projects/pgsql/sources/current/pgsql/src/test/regress/tmp_check/install/usr/lib/libpq.so.5.1

> LD_LIBRARY_PATH=/home/markus/projects/pgsql/sources/current/pgsql/src/test/regress/./tmp_check/install//usr/lib 
> ldd -r -v tmp_check/install/usr/bin/psql
>
[snip]
> Somebody have an idea on what's wrong here? Thanks.
>
>

Smells suspiciously like an rpath problem to me. What are your configure 
settings?

cheers

andrew