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

Tatsuo Ishii ishii at postgresql.org
Wed Feb 10 01:13:14 JST 2016


> 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

You should not install the package. It's different version.  You'd
better to ask SUSE support where to get proper package which includes
libpq-be.h.

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


More information about the pgpool-general mailing list