Contrib build fault for pgdg postgres 9.2 at debian 6 (squeeze)

From: Sergey Burladyan <eshkinkot(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Contrib build fault for pgdg postgres 9.2 at debian 6 (squeeze)
Date: 2015-02-13 17:35:35
Message-ID: CAJ2ymdj28rr20dnBs6WJ-ygjHQoZpGkbpt1bZhnxW4aDZdKRTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-02-13 18:13:02 Re: SELECT, GROUP BY, and aggregates
Previous Message Raymond O'Donnell 2015-02-13 17:10:20 Re: Collection