Re: [GENERAL] error while loading shared libraries: libpq.so.3

From: Richard Huxton <dev(at)archonet(dot)com>
To: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>, pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [GENERAL] error while loading shared libraries: libpq.so.3
Date: 2003-08-01 13:31:31
Message-ID: 200308011431.31423.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Corey.Brune 2003-08-01 13:49:06 Re: help needed for performance tuning
Previous Message Elielson Fontanezi 2003-08-01 11:54:10 error while loading shared libraries: libpq.so.3

Browse pgsql-general by date

  From Date Subject
Next Message Rory Campbell-Lange 2003-08-01 13:48:30 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message Ian Harding 2003-08-01 13:19:35 Re: Apache - DBI - Postgresql: Cancelling queries