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

[Yoshiyuki Asaba]

Hi,

From: gurkan at resolution.com
Subject: [Pgpool-general] cont. configure: error: libpq is not installed or libpq is old
Date: Tue, 03 Oct 2006 11:18:39 -0400 (EDT)

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

What a kind of query did you test? SELECT only?


> 2)Our servers running FC5-64bit with 32bit-enterprisedb. I am not able to
> configure it at all
> with or without options.

Hmm...
Could you compile this code?

--------------------------------
extern int PQprepare();
int main(void)
{
	int (*f)() = PQprepare;
	return 0;
}
---------------------------------

compile:
  % gcc -L/opt/EnterpriseDB/8.1.4.17/dbserver/lib -lpq x.c


> -----------------------------------------------------
> 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;
(snip)
> 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

It is link error. Could you show me the result of the following
command?

  % find /usr/local/lib -name libpq.a -print
  % find /usr/lib -name libpq.a -print
  % echo $LD_LIBRARY_PATH

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp