Thread: error while loading shared libraries: libpq.so.3

error while loading shared libraries: libpq.so.3

From

Elielson Fontanezi

Date:

01 August 2003, 08:52:39

Hi all!

I would like some suggestion on how to solve that:

postgres$ createdb postgres
/usr/local/postgresql-7.3.4/bin/psql: error while loading shared libraries: libpq.so.3: cannot open shared object file: No such file or directory
createdb: database creation failed
postgres$
postgres$ uname -a
Linux PgServer.prodam 2.4.18-14 #1 Wed Sep 4 11:57:57 EDT 2002 i586 i586 i386 GNU/Linux

thanks a lot!

                                   >\\\!/<     55 11 5080 9283
                                   !_"""_!     Elielson Fontanezi
                                   (O) (o)     PRODAM - Technical Support Analyst
-------------------------------oOOO--(_)--OOOo-----------------------------------
     Success usually comes to those who are too busy to be looking for it.
                            oooo0          0oooo
---------------------------(    )----------(    )--------------------------------
                            \ (            ) /
                             \_/            \_/

Re: error while loading shared libraries: libpq.so.3

From

Richard Huxton

Date:

01 August 2003, 10:31:38

On Friday 01 August 2003 12:54, Elielson Fontanezi wrote:
> Hi all!
>
>     I would like some suggestion on how to solve that:
>
> postgres$ createdb postgres
> /usr/local/postgresql-7.3.4/bin/psql: error while loading shared libraries:
> libpq.so.3: cannot open shared object file: No such file or directory
> createdb: database creation failed
> postgres$
> postgres$ uname -a
> Linux PgServer.prodam 2.4.18-14 #1 Wed Sep 4 11:57:57 EDT 2002 i586 i586
> i386 GNU/Linux

You probably need to add your library folder to /etc/ld.so.conf and then run
ldconfig.

Alternatively, you could symlink from /usr/local/lib to the library and do the
same for the binaries - that would mean you could skip the leading path when
running psql.

You can find the correct directory with:
  find /usr/local -name 'libpg.so.3'

There should be something on this in the installation instructions. In any
case, googling for "ldconfig" should find you some help.

--
  Richard Huxton
  Archonet Ltd