No lidbl.so in libpq.so (postgresql 8.4.4)

On Tue, May 25, 2010 at 7:48 PM, Gary Fu <gary.fu@sigmaspace.com> wrote:

Hi,

On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpool again
due to the libdl.so is not required in libpq.so (from the ldd command).  Do
you know how to build the 8.4.4 so that libdl.so is required in libpq.so ?

10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
/lib/libdl-2.6.1.so
/lib/libdl.so.2

10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
./src/interfaces/libpq/libpq.so
       linux-gate.so.1 =>  (0xffffe000)
       libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
       libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
       /lib/ld-linux.so.2 (0x80000000)

Thanks,
Gary

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Could you please explain a little more what you want to do actually ?

--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com

Nilesh Govindarajan wrote:

On Tue, May 25, 2010 at 7:48 PM, Gary Fu <gary.fu@sigmaspace.com> wrote:

Hi,

On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
postgresql 8.4.2. But when I upgraded to 8.4.4, I cannot build pgpool again
due to the libdl.so is not required in libpq.so (from the ldd command). Do
you know how to build the 8.4.4 so that libdl.so is required in libpq.so ?

10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
/lib/libdl-2.6.1.so
/lib/libdl.so.2

10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
./src/interfaces/libpq/libpq.so
linux-gate.so.1 => (0xffffe000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
/lib/ld-linux.so.2 (0x80000000)

Thanks,
Gary

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Could you please explain a little more what you want to do actually ?

I have the following problem to run 'configure' when building pgpool
2.3.3 with libpq from normal built of postgreSQL 8.4.4.

configure:24789: result: no
configure:24799: error: libpq is not installed or libpq is old

However, when I rebuilt the 8.4.4 with 'LDFLAGS='-ldl' during configure,
I don't have problem to build pgpool 2.3.3.

Thanks,
Gary

On Fri, May 28, 2010 at 10:13 PM, Gary Fu <gfu@sigmaspace.com> wrote:

Nilesh Govindarajan wrote:

On Tue, May 25, 2010 at 7:48 PM, Gary Fu <gary.fu@sigmaspace.com> wrote:

Hi,

On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpool
again
due to the libdl.so is not required in libpq.so (from the ldd command).
 Do
you know how to build the 8.4.4 so that libdl.so is required in libpq.so
?

10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
/lib/libdl-2.6.1.so
/lib/libdl.so.2

10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
./src/interfaces/libpq/libpq.so
      linux-gate.so.1 =>  (0xffffe000)
      libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
      libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
      /lib/ld-linux.so.2 (0x80000000)

Thanks,
Gary

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Could you please explain a little more what you want to do actually ?

I have the following problem to run 'configure' when building pgpool 2.3.3
with libpq from normal built of postgreSQL 8.4.4.

configure:24789: result: no
configure:24799: error: libpq is not installed or libpq is old

However, when I rebuilt the 8.4.4 with 'LDFLAGS='-ldl' during configure, I
don't have problem to build pgpool 2.3.3.

Thanks,
Gary

So your problem is sovled right ? Why worry then ?

--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com

On Fri, May 28, 2010 at 10:13 PM, Gary Fu <gfu@sigmaspace.com> wrote:

Nilesh Govindarajan wrote:

On Tue, May 25, 2010 at 7:48 PM, Gary Fu <gary.fu@sigmaspace.com> wrote:

Hi,

On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
postgresql 8.4.2.  But when I upgraded to 8.4.4, I cannot build pgpool
again
due to the libdl.so is not required in libpq.so (from the ldd command).
 Do
you know how to build the 8.4.4 so that libdl.so is required in libpq.so
?

10:16am 32 gfu@nppdist:~/postgres/postgresql-8.4.4> locate libdl
/lib/libdl-2.6.1.so
/lib/libdl.so.2

10:16am 33 gfu@nppdist:~/postgres/postgresql-8.4.4> ldd
./src/interfaces/libpq/libpq.so
      linux-gate.so.1 =>  (0xffffe000)
      libcrypt.so.1 => /lib/libcrypt.so.1 (0x40026000)
      libc.so.6 => /lib/i686/libc.so.6 (0x40054000)
      /lib/ld-linux.so.2 (0x80000000)

Thanks,
Gary

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Could you please explain a little more what you want to do actually ?

I have the following problem to run 'configure' when building pgpool 2.3.3
with libpq from normal built of postgreSQL 8.4.4.

configure:24789: result: no
configure:24799: error: libpq is not installed or libpq is old

However, when I rebuilt the 8.4.4 with 'LDFLAGS='-ldl' during configure, I
don't have problem to build pgpool 2.3.3.

He didn't have problem with PostgreSQL 8.4.2+pgpool-II 2.3.3 and he's
wondering why he now starts to have a problem with 8.4.4, I think.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

Gary Fu <gfu@sigmaspace.com> writes:

Nilesh Govindarajan wrote:

Could you please explain a little more what you want to do actually ?

I have the following problem to run 'configure' when building pgpool
2.3.3 with libpq from normal built of postgreSQL 8.4.4.

configure:24789: result: no
configure:24799: error: libpq is not installed or libpq is old

This is a bug in pgpool's configure script, which you should report to
them not us. It's not our responsibility to supply libdl.

regards, tom lane

On 05/28/2010 02:16 PM, Tom Lane wrote:

Gary Fu<gfu@sigmaspace.com> writes:

Nilesh Govindarajan wrote:

Could you please explain a little more what you want to do actually ?

I have the following problem to run 'configure' when building pgpool
2.3.3 with libpq from normal built of postgreSQL 8.4.4.

configure:24789: result: no
configure:24799: error: libpq is not installed or libpq is old

This is a bug in pgpool's configure script, which you should report to
them not us. It's not our responsibility to supply libdl.

regards, tom lane

run pgpool's configure with the options:

--with-psql=/dir/where/you/have/pg844
--with-psql-includedir=/dir/dir/where/you/have/pg844/include
--with-psql-libdir=/dir/dir/where/you/have/pg844/lib

Gary Fu <gfu@sigmaspace.com> writes:

Nilesh Govindarajan wrote:

Could you please explain a little more what you want to do actually ?

I have the following problem to run 'configure' when building pgpool
2.3.3 with libpq from normal built of postgreSQL 8.4.4.

configure:24789: result: no
configure:24799: error: libpq is not installed or libpq is old

This is a bug in pgpool's configure script, which you should report to
them not us. It's not our responsibility to supply libdl.

Starting from pgpool-II 2.3 it provides SSL support and it needs
libssl then libssl needs libdl. Because pgpool's configure does not
link libdl(which is a bug), pgpool relies on libpq's reference to
libdl. Unfortunately libpq does not refer to libdl unless libpq
is configured with SSL support. Probably his PostgreSQL 8.4.4 build
was made without SSL support. Sorry for making a noise.

I'm studying now libpq's build to know how to refer to libdl if SSL is
enabled...
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp