pg_config problems on PG9.3/Centos?

Поиск

Список

Период

Сортировка

От	Ken Tanzer
Тема	pg_config problems on PG9.3/Centos?
Дата	21 января 2014 г. 23:05:27
Msg-id	CAD3a31VzxnfwxiQ4MfTLvX2P+EFS+opDggNeHO+JkGOaM3XN7w@mail.gmail.com обсуждение исходный текст
Ответы	Re: pg_config problems on PG9.3/Centos?
Список	pgsql-general

Дерево обсуждения

Hi. I'm trying to build the table_log module for Postgres 9.3, and am wondering if there is an issue with pg_config. I installed Postgres on a fresh CentOS 6.5 with the pgdg packages:

yum list installed postgres*

Installed Packages

postgresql93.x86_64 9.3.2-1PGDG.rhel6 @pgdg93

postgresql93-contrib.x86_64 9.3.2-1PGDG.rhel6 @pgdg93

postgresql93-devel.x86_64 9.3.2-1PGDG.rhel6 @pgdg93

postgresql93-libs.x86_64 9.3.2-1PGDG.rhel6 @pgdg93

postgresql93-pltcl.x86_64 9.3.2-1PGDG.rhel6 @pgdg93

postgresql93-server.x86_64 9.3.2-1PGDG.rhel6 @pgdg93

I'm using this makefile, which has the path to pg_config hard-coded in it, with "make USE_PGXS=1":

MODULES = table_log

DATA_built = table_log.sql

DOCS = README.table_log

ifdef USE_PGXS

PGXS := $(shell /usr/pgsql-9.3/bin/pg_config --pgxs)

include $(PGXS)

else

subdir = contrib/table_log

top_builddir = ../..

include $(top_builddir)/src/Makefile.global

include $(top_srcdir)/contrib/contrib-global.mk

endif

This works for me on a similar pg 9.2/Centos 6 setup, but fails on 9.3:

table_log.c:14:22: error: postgres.h: No such file or directory

table_log.c:15:18: error: fmgr.h: No such file or directory

table_log.c:16:71: error: executor/spi.h: No such file or directory

table_log.c:17:53: error: commands/trigger.h: No such file or directory

table_log.c:18:65: error: mb/pg_wchar.h: No such file or directory

table_log.c:21:23: error: miscadmin.h: No such file or directory

table_log.c:22:30: error: utils/formatting.h: No such file or directory

table_log.c:23:28: error: utils/builtins.h: No such file or directory

table_log.c:24:29: error: utils/lsyscache.h: No such file or directory

table_log.c:25:21: error: funcapi.h: No such file or directory

When I look the output of pg_config, and especially compared to my 9.2 output, it seems suspiciously lacking some 9.3 paths:

[root@new-agency table_log-0.4.4]# pg_config | more

BINDIR = /usr/bin

DOCDIR = /usr/share/doc/pgsql

HTMLDIR = /usr/share/doc/pgsql

INCLUDEDIR = /usr/include

PKGINCLUDEDIR = /usr/include

INCLUDEDIR-SERVER = /usr/include/server

LIBDIR = /usr/lib

PKGLIBDIR = /usr/lib

LOCALEDIR = /usr/share/locale

MANDIR = /usr/share/man

SHAREDIR = /usr/share

SYSCONFDIR = /etc/sysconfig/pgsql

PGXS = /usr/lib/pgxs/src/makefiles/pgxs.mk

CONFIGURE = '--disable-rpath' '--prefix=/usr/pgsql-9.3' '--includedir=/usr/pgsql-9.3/include' '--mandir=/

usr/pgsql-9.3/share/man' '--datadir=/usr/pgsql-9.3/share' '--with-perl' '--with-python' '--with-tcl' '--w

ith-tclconfig=/usr/lib64' '--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' '--with-includes=/u

sr/include' '--with-libraries=/usr/lib64' '--enable-nls' '--with-ossp-uuid' '--with-libxml' '--with-libxs

lt' '--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--docdi

r=/usr/share/doc' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --par

am=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et' 'CPPFLAGS= -I/usr/include/et'

CC = gcc

CPPFLAGS = -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include

CFLAGS = -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-siz

e=4 -m64 -mtune=generic -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-

statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv

CFLAGS_SL = -fpic

LDFLAGS = -L../../../src/common -L/usr/lib64 -Wl,--as-needed

LDFLAGS_EX =

LDFLAGS_SL =

LIBS = -lpgport -lpgcommon -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -

VERSION = PostgreSQL 9.3.2

My 9.2 pg_config:

[root@hosting table_log-0.4.4]# pg_config

BINDIR = /usr/pgsql-9.2/bin

DOCDIR = /usr/share/doc/pgsql

HTMLDIR = /usr/share/doc/pgsql

INCLUDEDIR = /usr/pgsql-9.2/include

PKGINCLUDEDIR = /usr/pgsql-9.2/include

INCLUDEDIR-SERVER = /usr/pgsql-9.2/include/server

LIBDIR = /usr/pgsql-9.2/lib

PKGLIBDIR = /usr/pgsql-9.2/lib

LOCALEDIR = /usr/pgsql-9.2/share/locale

MANDIR = /usr/pgsql-9.2/share/man

SHAREDIR = /usr/pgsql-9.2/share

SYSCONFDIR = /etc/sysconfig/pgsql

PGXS = /usr/pgsql-9.2/lib/pgxs/src/makefiles/pgxs.mk

CONFIGURE = '--disable-rpath' '--prefix=/usr/pgsql-9.2' '--includedir=/usr/pgsql-9.2/include' '--mandir=/usr/pgsql-9.2/share/man' '--datadir=/usr/pgsql-9.2/share' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' '--with-includes=/usr/include' '--with-libraries=/usr/lib64' '--enable-nls' '--with-ossp-uuid' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/share/doc' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et' 'CPPFLAGS= -I/usr/include/et'

CC = gcc

CPPFLAGS = -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include

CFLAGS = -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv

CFLAGS_SL = -fpic

LDFLAGS = -L/usr/lib64 -Wl,--as-needed

LDFLAGS_EX =

LDFLAGS_SL =

LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm

VERSION = PostgreSQL 9.2.6

I could probably hack around this, but I'm wondering if I'm either missing some easy step, or if there's a problem with the 9.3 packages. Thanks in advance.

Ken