Thread: Library Error

I just installed PostgreSQL on a Linux machine and it seems to run fine.  However, I cannot do anything to it since I get the following error message everytime I run any program (except initdb, that worked):

psql: error in loading shared libraries: libpq.so.2.1: cannot open shared object
 file: No such file or directory

The file does exist in the /usr/local/pgsql/lib directory, I do have permissions for it, and I put lib in my path, yet it still complains.  Is there a .conf file parameter missing somewhere?  A configure param?

Any help would be appreciated.

John Sokel

I too have had the same problem.  Admittedly I haven't had
time to read too much about the finer points of installation, or
even administration for that matter.

I simple added /usr/local/pgslq/lib to my LD_LIBRARY_PATH and
that took care of it.

HTH,
-darrel

On Fri, 7 Jul 2000, Sokel, John wrote:

> I just installed PostgreSQL on a Linux machine and it seems to run fine.
> However, I cannot do anything to it since I get the following error message
> everytime I run any program (except initdb, that worked):
>
> psql: error in loading shared libraries: libpq.so.2.1: cannot open shared
> object
>  file: No such file or directory
>
> The file does exist in the /usr/local/pgsql/lib directory, I do have
> permissions for it, and I put lib in my path, yet it still complains.  Is
> there a .conf file parameter missing somewhere?  A configure param?
>
> Any help would be appreciated.
>
> John Sokel
>

Add this to your environment:

LD_LIBRARY_PATH=/usr/local/pgsql/lib:$LD_LIBRARY_PATH

(lib doesnt need to be in $PATH, that's just for executables, this is a shared library)

Jacques Williams

On Fri, Jul 07, 2000 at 11:14:24AM -0500, Sokel, John wrote:
> I just installed PostgreSQL on a Linux machine and it seems to run fine.
> However, I cannot do anything to it since I get the following error message
> everytime I run any program (except initdb, that worked):
>
> psql: error in loading shared libraries: libpq.so.2.1: cannot open shared
> object
>  file: No such file or directory
>
> The file does exist in the /usr/local/pgsql/lib directory, I do have
> permissions for it, and I put lib in my path, yet it still complains.  Is
> there a .conf file parameter missing somewhere?  A configure param?
>
> Any help would be appreciated.
>
> John Sokel

"Sokel, John" wrote:
  >I just installed PostgreSQL on a Linux machine and it seems to run fine.
  >However, I cannot do anything to it since I get the following error message
  >everytime I run any program (except initdb, that worked):
  >
  >psql: error in loading shared libraries: libpq.so.2.1: cannot open shared
  >object
  > file: No such file or directory
  >
  >The file does exist in the /usr/local/pgsql/lib directory, I do have
  >permissions for it, and I put lib in my path, yet it still complains.  Is
  >there a .conf file parameter missing somewhere?  A configure param?

You need to run ldconfig to tell the system where to find it.  (Read the
man page for detailed instructions.)

Alternatively, make sure that LD_LIBRARY_PATH includes /usr/local/pgsql/lib,
and is exported in your environment.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "I waited patiently for the LORD; and he inclined unto
      me, and heard my cry. He brought me up also out of an
      horrible pit, out of the miry clay, and set my feet
      upon a rock, and established my goings. And he hath
      put a new song in my mouth, even praise unto our God.
      Many shall see it, and fear, and shall trust in the
      LORD."                 Psalms 40:1-3