saravanan <saravanan.kcse@gmail.com> writes:
> [postgres@oracle bin]$ pg_config --libdir
> /usr/local/pgsql/lib
> [postgres@oracle bin]$ pg_config --pkglibdir
> /usr/local/pgsql/lib
> I set environment variables in .bash_profile
> LD_LIBRARY_PATH=/usr/local/pgsql/lib
> export LD_LIBRARY_PATH
That would only help if it were in the environment of the running server
process. Depending on how you start Postgres, putting it in the
postgres user's .bash_profile and restarting the server might get the
job done ... but it's also possible you need to change your server start
script.
regards, tom lane