[pgpool-general: 4422] Re: [Problem] libpq is not installed or libpq is old

[Jorge Luis Iten Júnior]

Hi, thanks for th reply.

I was unable to find postgresql-devel in package manager, so I installed
this postgresql-devel-9.0.3-1.6.1.x86_64.rpm, so after "find / -type f
-iname '*libpq*'" I find

/usr/include/pgsql/internal/libpq-int.h
/usr/include/pgsql/libpq/libpq-fs.h
/usr/include/pgsql/libpq-events.h
/usr/include/pgsql/libpq-fe.h
/usr/include/pgsql/server/libpq/libpq-fs.h
/usr/include/pgsql/server/libpq/libpq.h
/usr/include/pgsql/server/libpq/libpq-be.h
/usr/lib64/libpq.so.5.7

./configure --with-pgsql-libdir=/usr/lib64
--with-pgsql-includedir=/usr/include/pgsql/ without success.
Also, I noticed that pg_control version is different from postgreSQL which
is 9.4.4.

 # pg_config
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/packages/postgresql
HTMLDIR = /usr/share/doc/packages/postgresql
INCLUDEDIR = /usr/include/pgsql
PKGINCLUDEDIR = /usr/include/pgsql
INCLUDEDIR-SERVER = /usr/include/pgsql/server
LIBDIR = /usr/lib64
PKGLIBDIR = /usr/lib64/postgresql
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/man
SHAREDIR = /usr/share/postgresql
SYSCONFDIR = /etc/postgresql
PGXS = /usr/lib64/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--host=x86_64-unknown-linux-gnu'
'--build=x86_64-unknown-linux-gnu' '--program-prefix=' '--prefix=/usr'
'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
'--libdir=/usr/lib64' '--libexecdir=/usr/lib' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--includedir=/usr/include/pgsql'
'--datadir=/usr/share/postgresql' '--docdir=/usr/share/doc/packages'
'--disable-rpath' '--enable-nls' '--enable-thread-safety'
'--enable-integer-datetimes' '--without-readline' '--with-openssl'
'--with-ldap' '--with-gssapi' '--with-libxml' '--with-libxslt'
'--with-krb5' '--with-system-tzdata=/usr/share/zoneinfo'
'build_alias=x86_64-unknown-linux-gnu'
'host_alias=x86_64-unknown-linux-gnu' 'CFLAGS=-fmessage-length=0 -O2 -Wall
-D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables
-fasynchronous-unwind-tables -g '
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS = -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector
-funwind-tables -fasynchronous-unwind-tables -g  -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing -fwrapv
CFLAGS_SL = -fpic
LDFLAGS = -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5
-lz -lcrypt -ldl -lm
VERSION = PostgreSQL 9.0.3





On Tue, Feb 9, 2016 at 9:53 AM Tatsuo Ishii <ishii at postgresql.org> wrote:

> > I have PostgreSQL 9.4 installed on a SUSE-Linux-Enterprise-Server-11-SP4
> > 11.4.4-1.109 and now I am trying to configure pgpool II, I have
> downloaded
> > pgpool-II-3.5.0.tar.gz. When I run ./configure this message, according to
> > the tutorial I tried this:
> >  find / -type f -iname "*libpq*"
> > /usr/lib64/libpq.so.5.7
> > --
> > ./configure --with-pgsql-libdir=/usr/lib64/libpq.so.5.7
> > ./configure --with-pgsql-libdir=/usr/lib64/
> > ./configure --with-pgsql=/usr/lib64/
> > export LD_LIBRARY_PATH=/usr/lib64/
> > ./configure
> >
> > I am still viewing this message. Any tip?
> > Thanks in advance.
>
> I am not familiar with SUSE packaging, but I guess you need libpq
> development package (header files) be installed.
>
> Also I wonder if you have pg_config command be installed and it's in
> your command search path. If yes, you should be able to run
> ./configure without options to specify libpq location. If not, please
> try:
>
> ./configure --with-pgsql-libdir=/usr/lib64
> --with-pgsql-includedir=path-to-the-dir-where-libpq-fe.h-exists
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160209/eb7324cc/attachment-0001.html>