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

error loading shared libraries: libpq.so.3

From

"Patrick Hatcher"

Date:

22 November 2003, 16:29:23

Doing an upgrade on RH 8 box from 7.3.4 to 7.4 from source.  The
installation appeared go smoothly.  I tried to reinstall my database using
psql -d someda -f data.file and I get the error message:
error while loading shared libraries: libpq.so.3:  cannot open shared
object file: No such file or directory exists.
However, if I do a find for this file, I find it in my PG directory:
/usr/local/postgresql7.4/lib

I'm not sure what to do now.  Any suggestions?
TIA

Patrick Hatcher

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

From

Martin Marques

Date:

22 November 2003, 17:05:58

El Sáb 22 Nov 2003 17:20, Patrick Hatcher escribió:
> Doing an upgrade on RH 8 box from 7.3.4 to 7.4 from source.  The
> installation appeared go smoothly.  I tried to reinstall my database using
> psql -d someda -f data.file and I get the error message:
> error while loading shared libraries: libpq.so.3:  cannot open shared
> object file: No such file or directory exists.
> However, if I do a find for this file, I find it in my PG directory:
> /usr/local/postgresql7.4/lib
>
> I'm not sure what to do now.  Any suggestions?

It's not in the library path.
Add /usr/local/postgresql7.4/lib to the /etc/ld.so.conf file and run ldconfig.
That should do it.

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

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

From

"Patrick Hatcher"

Date:

22 November 2003, 20:44:37

<FONT face=3D"Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" si=
ze=3D2>Thanks that did itPatrick Hatcher<DIV=
>-----Martin Marques <martin@bugs.unl.ed=
u.ar> wrote: -----To: "Patrick Hatcher" <PHatcher@macy=
s.com>, pgsql-general@postgresql.orgFrom: Martin Marques <martin@=
bugs.unl.edu.ar>Date: 2003-11-22 03:08PMSubject: Re: [GENERAL] e=
rror loading shared libraries: libpq.so.3<font face=3D"monospace" s=
ize=3D2>El S=E1b 22 Nov 2003 17:20, Patrick Hatcher escribi=F3:> Doi=
ng an upgrade on RH 8 box from 7.3.4 to 7.4 from source.  The> =
installation appeared go smoothly.  I tried to reinstall my database u=
sing> psql -d someda -f data.file and I get the error message:&g=
t; error while loading shared libraries: libpq.so.3:  cannot open shar=
ed> object file: No such file or directory exists.> However, =
if I do a find for this file, I find it in my PG directory:> /usr/lo=
cal/postgresql7.4/lib> > I'm not sure what to do now.  A=
ny suggestions?It's not in the library path.Add /usr/local/post=
gresql7.4/lib to the /etc/ld.so.conf file and run ldconfig. That should=
 do it.-- select 'mmarques' || '@' || 'unl.edu.ar' AS email;<BR=
>-----------------------------------------------------------------Mart=
=EDn Marqu=E9s                 &nbs=
p;|        mmarques@unl.edu.arProgramador, Administ=
rador, DBA |       Centro de Telem=E1tica     =
                  Universidad =
Nacional                  =
          del Litoral-------------------------=
----------------------------------------