Distro and version: Ubuntu 16.04 LTS.
If memory serves, I installed 9.5 using synaptic and 9.6 using apt-get, where I followed the instructions from this site: https://www.postgresql.org/download/linux/ubuntu/
I also have an anaconda installation of postgresql, but that is a version less than 9.6.
Here are the results for postgresql using dpkg-query -l
ii postgresql 9.5+173 all object-relational SQL database (supported version)
ii postgresql-9.5 9.5.3-0ubuntu0.16.04 amd64 object-relational SQL database, version 9.5 server
ii postgresql-9.6 9.6.5-1.pgdg16.04+2 amd64 object-relational SQL database, version 9.6 server
ii postgresql-client-9.5 9.5.3-0ubuntu0.16.04 amd64 front-end programs for PostgreSQL 9.5
ii postgresql-client-9.6 9.6.5-1.pgdg16.04+2 amd64 front-end programs for PostgreSQL 9.6
ii postgresql-client-common 173 all manager for multiple PostgreSQL client versions
ii postgresql-common 173 all PostgreSQL database-cluster manager
ii postgresql-contrib-9.5 9.5.3-0ubuntu0.16.04 amd64 additional facilities for PostgreSQL
ii postgresql-contrib-9.6 9.6.5-1.pgdg16.04+2 amd64 additional facilities for PostgreSQL
ii postgresql-server-dev-9.5 9.5.3-0ubuntu0.16.04 amd64 development files for PostgreSQL 9.5 server-side programming
ii postgresql-server-dev-9.6 9.6.5-1.pgdg16.04+2 amd64 development files for PostgreSQL 9.6 server-side programming
On Fri, Jan 5, 2018 at 10:24 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 01/05/2018 09:07 AM, Travis Allison wrote:
PGXS = /usr/lib/postgresql/9.6/lib/pgHi,
I have postgres 9.5 and 9.6 installed. pg_config points to 9.6.
I am trying to compile a postgresql plugin (Timescaledb). I am getting an error:
-----------------------------------------------
/usr/include/postgresql/pg_config.h:733:0: warning: "PACKAGE_VERSION" redefined
#define PACKAGE_VERSION "10.0"
^
In file included from /usr/include/postgresql/9.6/server/c.h:53:0,
from /usr/include/postgresql/9.6/server/postgres.h:47,
from /mnt/data/timescaledb/src/init.c:1:
/usr/include/postgresql/9.6/server/pg_config.h:740:0: note: this is the location of the previous definition
#define PACKAGE_VERSION "9.6.5"
-----------------------------------------------------
The command pg_config gives the following:
---------------------------------------
BINDIR = /usr/lib/postgresql/9.6/bin
DOCDIR = /usr/share/doc/postgresql-doc-9.6
HTMLDIR = /usr/share/doc/postgresql-doc-9.6
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/9.6/server
LIBDIR = /usr/lib/x86_64-linux-gnu
PKGLIBDIR = /usr/lib/postgresql/9.6/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/9.6/man
SHAREDIR = /usr/share/postgresql/9.6
SYSCONFDIR = /etc/postgresql-commonxs/src/makefiles/pgxs.mk <http://pgxs.mk>
CONFIGURE = '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-openssl' '--with-libxml' '--with-libxslt' '--with-tclconfig=/usr/lib/x86_64-linux-gnu/tcl8.6' '--with-includes=/usr/include/ tcl8.6' 'PYTHON=/usr/bin/python' '--mandir=/usr/share/postgresq l/9.6/man' '--docdir=/usr/share/doc/postg resql-doc-9.6' '--sysconfdir=/etc/postgresql- common' '--datarootdir=/usr/share/' '--datadir=/usr/share/postgres ql/9.6' '--bindir=/usr/lib/postgresql/ 9.6/bin' '--libdir=/usr/lib/x86_64-linu x-gnu/' '--libexecdir=/usr/lib/postgre sql/' '--includedir=/usr/include/pos tgresql/' '--enable-nls' '--enable-integer-datetimes' '--enable-thread-safety' '--enable-tap-tests' '--enable-debug' '--disable-rpath' '--with-uuid=e2fs' '--with-gnu-ld' '--with-pgport=5432' '--with-system-tzdata=/usr/sha re/zoneinfo' '--with-systemd' 'CFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fPIC -pie -fno-omit-frame-pointer' 'LDFLAGS=-Wl,-Bsymbolic-functi ons -Wl,-z,relro -Wl,-z,now' '--with-gssapi' '--with-ldap' '--with-includes=/usr/include/ mit-krb5' '--with-libs=/usr/lib/mit-krb5 ' '--with-libs=/usr/lib/x86_64-l inux-gnu/mit-krb5' '--with-selinux' 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2'
CC = gcc
CPPFLAGS = -DFRONTEND -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/mit-krb5
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fPIC -pie -fno-omit-frame-pointer
CFLAGS_SL = -fPIC
LDFLAGS = -L../../src/common -Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lselinux -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -ledit -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 9.6.5
-------------------------------------------------
So my question is: what is generating the /usr/include/postgresql/pg_config.h file? Why is it different than the /usr/include/postgresql/9.6/se rver/pg_config.h file?
I am guessing you have some part of Postgres 10 installed. During the build the extension is getting to /usr/include/postgresql/pg_config.h before it gets to /usr/include/postgresql/9.6/se rver/pg_config.h. Crank up your package manager and see what your distro has installed? Along that line knowing what distro and version you are using as well as how you installed Postgres 9.5 and 9.6 would be helpful.
Thanks!
Travis
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
