Hello All!
I install postgresql-server-dev-9.2 from
'deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main'
and try to build contrib module from 9.2 but it fault with error:
====
$ make USE_PGXS=1 PG_CONFIG=/usr/lib/postgresql/9.2/bin/pg_config
gcc -g -O2 -I/usr/include/mit-krb5 -fPIC -pie -DLINUX_OOM_ADJ=0
-fno-omit-frame-pointer -I/usr/include/mit-krb5 -fPIC -pie
-DLINUX_OOM_ADJ=0 -fno-omit-frame-pointer -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
-fwrapv -g -pthread -D_REENTRANT -D_THREAD_SAFE
-D_POSIX_PTHREAD_SEMANTICS -I/usr/include/postgresql -I. -I./
-I/usr/include/postgresql/9.2/server
-I/usr/include/postgresql/internal -D_GNU_SOURCE
-I/usr/include/libxml2 -I/usr/include/tcl8.5 -c -o pgbench.o
pgbench.c
In file included from pgbench.c:37:
/usr/include/postgresql/libpq-fe.h:547: error: expected '=', ',', ';',
'asm' or '__attribute__' before 'lo_lseek64'
/usr/include/postgresql/libpq-fe.h:551: error: expected '=', ',', ';',
'asm' or '__attribute__' before 'lo_tell64'
/usr/include/postgresql/libpq-fe.h:553: error: expected declaration
specifiers or '...' before 'pg_int64'
make: *** [pgbench.o] Error 1
====
How can I solve this?
/usr/include/postgresql/libpq-fe.h is from libpq-dev, looks like
libpq-dev have wrong version:
====
$ dpkg -S /usr/include/postgresql/libpq-fe.h
libpq-dev: /usr/include/postgresql/libpq-fe.h
$ apt-cache policy libpq-dev
libpq-dev:
Installed: 9.4.1-1.pgdg60+1
Candidate: 9.4.1-1.pgdg60+1
Version table:
*** 9.4.1-1.pgdg60+1 0
500 http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg/main
amd64 Packages
100 /var/lib/dpkg/status
8.4.21-0squeeze1 0
500 http://mirror.yandex.ru/debian/ squeeze/main amd64 Packages
8.4.20-0squeeze1 0
500 http://security.debian.org/ squeeze/updates/main amd64 Packages
--
Sergey Burladyan