Re: Importing the dump file in postgresql-7.4.23

saravanan <saravanan(dot)kcse(at)gmail(dot)com> writes:
> [postgres(at)oracle bin]$ pg_config --libdir
> /usr/local/pgsql/lib
> [postgres(at)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