error loading shared libraries: libpq.so.3

Started by Patrick Hatcherover 22 years ago3 messagesgeneral
Jump to latest
#1Patrick Hatcher
PHatcher@macys.com

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

#2Martín Marqués
martin@bugs.unl.edu.ar
In reply to: Patrick Hatcher (#1)
Re: error loading shared libraries: libpq.so.3

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
-----------------------------------------------------------------

#3Patrick Hatcher
PHatcher@macys.com
In reply to: Martín Marqués (#2)
Re: error loading shared libraries: libpq.so.3

<FONT face="Default Sans Serif, Verdana, Arial, Helvetica, sans-serif" size=2><DIV>Thanks that did it<BR><DIV><br><br>Patrick&nbsp;Hatcher<br><DIV><BR></DIV><FONT color=#990099>-----Martin Marques &lt;martin@bugs.unl.edu.ar&gt; wrote: -----<BR><BR></FONT>To: "Patrick Hatcher" &lt;PHatcher@macys.com&gt;, pgsql-general@postgresql.org<BR>From: Martin Marques &lt;martin@bugs.unl.edu.ar&gt;<BR>Date: 2003-11-22 03:08PM<BR>Subject: Re: [GENERAL] error loading shared libraries: libpq.so.3<BR><BR><font face="monospace" size=2>El Sáb 22 Nov 2003 17:20, Patrick Hatcher escribió:<BR>&gt; Doing an upgrade on RH 8 box from 7.3.4 to 7.4 from source. &nbsp;The<BR>&gt; installation appeared go smoothly. &nbsp;I tried to reinstall my database using<BR>&gt; psql -d someda -f data.file and I get the error message:<BR>&gt; error while loading shared libraries: libpq.so.3: &nbsp;cannot open shared<BR>&gt; object file: No such file or directory exists.<BR>&gt; However, if I do a find for this file, I find it in my PG directory:<BR>&gt; /usr/local/postgresql7.4/lib<BR>&gt; <BR>&gt; I'm not sure what to do now. &nbsp;Any suggestions?<BR><BR>It's not in the library path.<BR>Add /usr/local/postgresql7.4/lib to the /etc/ld.so.conf file and run ldconfig. <BR>That should do it.<BR><BR>-- <BR>select 'mmarques' || '@' || 'unl.edu.ar' AS email;<BR>-----------------------------------------------------------------<BR>Martín Marqués &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| &nbsp; &nbsp; &nbsp; &nbsp;mmarques@unl.edu.ar<BR>Programador, Administrador, DBA | &nbsp; &nbsp; &nbsp; Centro de Telemática<BR> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Universidad Nacional<BR> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;del Litoral<BR>-----------------------------------------------------------------<BR><BR></font></DIV></DIV></FONT>

From pgsql-general-owner@postgresql.org Sun Nov 23 03:38:39 2003

X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
by svr1.postgresql.org (Postfix) with ESMTP id 886AAD1D82F
for <pgsql-general-postgresql.org@localhost.postgresql.org>; Sun, 23 Nov 2003 07:38:33 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
with ESMTP id 33860-10
for <pgsql-general-postgresql.org@localhost.postgresql.org>;
Sun, 23 Nov 2003 03:38:03 -0400 (AST)
Received: from lmsmtp01.st1.spray.net (lmsmtp01.st1.spray.net [212.78.202.111])
by svr1.postgresql.org (Postfix) with ESMTP id 120F2D1D882
for <pgsql-general@postgresql.org>; Sun, 23 Nov 2003 03:38:01 -0400 (AST)
Received: from dumco (unknown [203.129.254.138])
by lmsmtp01.st1.spray.net (Postfix) with ESMTP
id 7E9FF1E79C; Sun, 23 Nov 2003 08:37:58 +0100 (MET)
Message-ID: <001901c3b194$b72383a0$1a0110ac@dumco>
From: "Durai" <visolve_postgres@lycos.co.uk>
To: "Alvaro Herrera" <alvherre@dcc.uchile.cl>
Cc: <pgsql-general@postgresql.org>
References: <0a1501c3af7f$e6b22d90$1a0110ac@dumco> <20031122142235.GA6016@dcc.uchile.cl>
Subject: Re: Multiuser testing -- PostgreSQL 7.3.4
Date: Sun, 23 Nov 2003 13:06:48 +0530
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200311/1279
X-Sequence-Number: 52929

Thanks to all for providing information about concurent testing.

Regs,
Durai.

----- Original Message -----
From: "Alvaro Herrera" <alvherre@dcc.uchile.cl>
To: "Durai" <visolve_postgres@lycos.co.uk>
Cc: <pgsql-general@postgresql.org>
Sent: Saturday, November 22, 2003 7:52 PM
Subject: Re: [GENERAL] Multiuser testing -- PostgreSQL 7.3.4

On Thu, Nov 20, 2003 at 09:33:48PM +0530, Durai wrote:

How to test the "Multiuser testing" in PostgreSQL?. I

used

the apache bench "ab" tool for this one.

For a real world test you would need several scripts doing different
things: updates to different rows, insertions, maybe deletes. Set them up

to

be reachable from your web server somehow, and then pass the URLs to siege
(http://joedog.org/siege/).

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
(Samuel P. Huntington)

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 11/10/2003