Thread: Problem with libpq.so.5 in pgadmin3-1.10.2

Please keep the list on CC.

Le 17/03/2010 15:22, Vinicius Borges a écrit :

> #$ ldd /usr/local/pgadmin3/bin/pgadmin3

>[...]

>     libpq.so.5 => not found

ldd doesn't find it too. Kind of strange. How did you install libpq? did
you install the 32-bits library? (which would explain where it is
located and why ldd didn't find it). But it won't explain why you could
compile without the library.


--

Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

On Wed, 2010-03-17 at 12:37 -0300, Vinicius Borges wrote:
> /usr/local/pgadmin3/bin/pgadmin3: error while loading shared
> libraries:
> /usr/lib64/libpq.so.5: ELF file OS ABI invalid

You may need to compile your own libpq from using PostgreSQL 8.2...

--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

What is the output of the following commands:

file /usr/local/pgadmin3/bin/pgadmin3

file /usr/local/lib/libpq.so.5

--

Ashesh

On Wed, Mar 17, 2010 at 6:39 PM, Vinicius Borges <contatovrpb@gmail.com> wrote:

Hello,

I installed pgadmin3-1.10.2 and I got an error that might strange...

bash-3.1# /usr/local/pgadmin3/bin/pgadmin3
/usr/local/pgadmin3/bin/pgadmin3: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

I have the libpq.so.5 in /usr/lib and /usr/local/lib.

I installed the wxWidgets 2.8.10, libxslt-1.1.24, libxml2-2.7.4-1 and postgresql-libs-8.4.2-6.

I'm on Slackware 13 - 64 bit.

Thanks

Hello Ashesh,

when I type

bash-3.1# file /usr/local/pgadmin3/bin/pgadmin3
/usr/local/pgadmin3/bin/pgadmin3: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), not stripped

and

bash-3.1# file /usr/local/lib/libpq.so.5
/usr/local/lib/libpq.so.5: ELF 32-bit LSB shared object, Intel 80386, version 1 (GNU/Linux), dynamically linked, stripped

Hi Vinicius,

On Thu, Mar 18, 2010 at 4:04 PM, Vinicius Borges <contatovrpb@gmail.com> wrote:

Hello Ashesh,

when I type

bash-3.1# file /usr/local/pgadmin3/bin/pgadmin3
/usr/local/pgadmin3/bin/pgadmin3: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), not stripped

This says - pgadmin3 is 64 bit binary.

and

bash-3.1# file /usr/local/lib/libpq.so.5
/usr/local/lib/libpq.so.5: ELF 32-bit LSB shared object, Intel 80386, version 1 (GNU/Linux), dynamically linked, stripped

And, libpq.so.5 is 32 bit binary.

In order to run the pgAdmin3, you need 64 bit libpq.so.5.

How did you install pgadmin3?

--

Thanks & Regards,

Ashesh Vashi

EnterpriseDB INDIA: Enterprise Postgres Company

On Thu, Mar 18, 2010 at 5:43 PM, Vinicius Borges <contatovrpb@gmail.com> wrote:

I installed the pgadmin3 using the file INSTALL in the source path.
After installation, with this problems, I downloaded the postgresql-libs(that has libpq.so.5) for 64 bit and manually copied the libpq.so.5 to /usr/lib64 and /usr/lib.

Did I make a mistake?

I think - you copied only the libpq.so.5.

Is that right or you also copied the other libraries too?

What is the output of the following command?

ldd /usr/lib64/libpq.so.5

--

Thanks & Regards,

Ashesh Vashi

EnterpriseDB INDIA: Enterprise Postgres Company