saravanan <saravanan.kcse@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin