Re: Setting up Postgresql on Linux

On Thu, 4 Mar 2004, phil campaigne wrote:

> 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???

Are you exporting those same settings in your .bash_profile or whatever is
setting up your environ?