Re: psql error:cannot open libpq.so.3

Phil Campaigne <pcampaigne(at)charter(dot)net> writes:
> -bash-2.05b$ psql -h localhost -U postgres nba
> psql: error while loading shared libraries: libpq.so.3: cannot open
> shared object file: No such file or directory

This could mean either that libpq.so itself is not where your dynamic
linker will look for it, or that some library it depends on (libssl
is a possible example) is not where your dynamic linker will look for
it.

Try first "ldd /path/to/psql" to verify that psql's reference to
libpq.so is being resolved sanely. If so, do ldd on libpq.so to see how
its references are resolved (or not). If necessary, check the
referenced libraries, etc, till you find what's not resolved.

Once you know where the problem is, install the needed library, or
update your ldconfig configuration so it can find that library.

regards, tom lane