[Pgpool-general] cont. configure: error: libpq is not installed or libpq is old

[gurkan at resolution.com]

Hi,
I have to clear out three things.
-----------------------------------------------------
1)On our cluster we are using pgpool3.1, and testing shows that say logging
takes 6-10sec
without pgpool, and 30-40sec with pgpool. I have told this is not good eneough.
Is this difference
expected? (then I am trying to use pgpool-II to see speed difference)
-----------------------------------------------------
2)Our servers running FC5-64bit with 32bit-enterprisedb. I am not able to
configure it at all
with or without options.

[root at baba1 pgpool-II-1.0.1]# ./configure
--with-pgsql=/opt/EnterpriseDB/8.1.4.17/dbserver/
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
...
...
checking for asprintf... yes
checking for PQprepare in -lpq... no
configure: error: libpq is not installed or libpq is old

here I run the commands you suggested;
[root at baba1 pgpool-II-1.0.1]# nm /opt/EnterpriseDB/8.1.4.17/dbserver/lib/libpq.a
| grep PQprepare
0000000000003860 T PQprepare
00000000000037c0 T PQprepareOut
[root at baba1 pgpool-II-1.0.1]# nm /usr/local/lib/libpq.a | grep PQprepare
nm: '/usr/local/lib/libpq.a': No such file
[root at baba1 pgpool-II-1.0.1]# nm /usr/lib64/libpq.a | grep PQprepare
nm: '/usr/lib64/libpq.a': No such file
[root at baba1 pgpool-II-1.0.1]# ls /usr/
bin/      etc/      games/    include/  kerberos/ lib/      lib64/    libexec/ 
local/    sbin/     share/    src/      tmp/      X11R6/

-----------------------------------------------------
3)Just to give and idea, I have tried it on my actual host which is not 64bit.
It configures only with option, but make gives error;

....
....
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands
[root at gurkan pgpool-II-1.0.1]# make
make  all-recursive
make[1]: Entering directory `/tmp/pgpool-II-1.0.1'
Making all in parser
make[2]: Entering directory `/tmp/pgpool-II-1.0.1/parser'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/tmp/pgpool-II-1.0.1/parser'
Making all in pcp
make[2]: Entering directory `/tmp/pgpool-II-1.0.1/pcp'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/tmp/pgpool-II-1.0.1/pcp'
make[2]: Entering directory `/tmp/pgpool-II-1.0.1'
/bin/sh ./libtool --mode=link gcc  -O3 -mcpu=pentium4 -march=pentium4 -mmmx
-msse -msse2 -mfpmath=sse   -o pgpool -lpq
-Wl,-L,/opt/EnterpriseDB/8.1.4.17/dbserver/lib
-Wl,-rpath,/opt/EnterpriseDB/8.1.4.17/dbserver/lib main.o child.o pool_auth.o
pool_config.o pool_error.o pool_process_query.o pool_stream.o
pool_connection_pool.o pool_params.o pool_signal.o pcp_child.o md5.o
pool_shmem.o pool_sema.o pool_system.o pool_rewrite_query.o
pool_rewrite_outfuncs.o pool_query_cache.o parser/libsql-parser.a pcp/libpcp.la
-lresolv -lnsl -lm
mkdir .libs
gcc -O3 -mcpu=pentium4 -march=pentium4 -mmmx -msse -msse2 -mfpmath=sse -o
.libs/pgpool -Wl,-L -Wl,/opt/EnterpriseDB/8.1.4.17/dbserver/lib -Wl,-rpath
-Wl,/opt/EnterpriseDB/8.1.4.17/dbserver/lib main.o child.o pool_auth.o
pool_config.o pool_error.o pool_process_query.o pool_stream.o
pool_connection_pool.o pool_params.o pool_signal.o pcp_child.o md5.o
pool_shmem.o pool_sema.o pool_system.o pool_rewrite_query.o
pool_rewrite_outfuncs.o pool_query_cache.o  -lpq parser/libsql-parser.a
pcp/.libs/libpcp.so -lresolv -lnsl -lm -Wl,--rpath -Wl,/usr/local/lib
pool_system.o(.text+0xcec): In function `pool_get_id':
: undefined reference to `PQprepare'
pool_query_cache.o(.text+0x103a): In function `pool_query_cache_register':
: undefined reference to `PQprepare'
collect2: ld returned 1 exit status
make[2]: *** [pgpool] Error 1
make[2]: Leaving directory `/tmp/pgpool-II-1.0.1'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/tmp/pgpool-II-1.0.1'
make: *** [all] Error 2
-----------------------------------------------------

but I really need to find out 1 and 2
thanks

-------------------------------------------------
This mail sent through IMP: www.resolution.com