Bug report: Wrong version in pg_config
Hi,
I'm using postgresql 8.3 in my Ubuntu 8.04 dekstop computer. I have tried to
install postgresql 8.4 for some testing, and removed it afterwards
using *apt-get
purge*.
There are currently no 8.4 packages installed:
*$ dpkg --get-selections | grep postgresql*
postgresql-8.3 install
postgresql-8.3-postgis install
postgresql-client-8.3 install
postgresql-client-common install
postgresql-common install
postgresql-contrib-8.3 install
postgresql-doc-8.3 install
postgresql-plpython-8.3 install
postgresql-server-dev-8.3 install
But still, pg_config remains with the removed version, after postresql
restart and even total reboot:
*$ pg_config*
BINDIR = /usr/lib/postgresql/8.4/bin
DOCDIR = /usr/share/doc/postgresql
HTMLDIR = /usr/share/doc/postgresql
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/8.4/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql/8.4/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/8.4/man
SHAREDIR = /usr/share/postgresql/8.4
SYSCONFDIR = /etc/postgresql-common
PGXS = /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--build=x86_64-linux-gnu' '--prefix=/usr'
'--includedir=/usr/include' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--sysconfdir=/etc' '--localstatedir=/var'
'--libexecdir=/usr/lib/postgresql-8.4' '--disable-maintainer-mode'
'--disable-dependency-tracking' '--srcdir=.'
'--mandir=/usr/share/postgresql/8.4/man'
'--with-docdir=/usr/share/doc/postgresql-doc-8.4'
'--sysconfdir=/etc/postgresql-common' '--datadir=/usr/share/postgresql/8.4'
'--bindir=/usr/lib/postgresql/8.4/bin'
'--includedir=/usr/include/postgresql/' '--enable-nls'
'--enable-integer-datetimes' '--enable-thread-safety' '--enable-debug'
'--disable-rpath' '--with-tcl' '--with-perl' '--with-python' '--with-pam'
'--with-krb5' '--with-gssapi' '--with-openssl' '--with-libxml'
'--with-libxslt' '--with-ldap' '--with-ossp-uuid' '--with-gnu-ld'
'--with-tclconfig=/usr/lib/tcl8.5' '--with-tkconfig=/usr/lib/tk8.5'
'--with-includes=/usr/include/tcl8.5'
'--with-system-tzdata=/usr/share/zoneinfo' '--with-pgport=5432' 'CFLAGS=-g
-O2 -g -Wall -O2 -fPIC' 'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,--as-needed'
'build_alias=x86_64-linux-gnu' 'CC=cc' 'CPPFLAGS='
CC = cc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/tcl8.5
CFLAGS = -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing -fwrapv -g
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err
-lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm
This creates confusion with external software packages trying to use pgxs,
for example.
Any ideas how to solve this?
Thanks,
Adam
Adam Matan <adam@linqmap.com> writes:
But still, pg_config remains with the removed version, after postresql restart and even total reboot:
$ pg_config
BINDIR = /usr/lib/postgresql/8.4/bin
[...]
This creates confusion with external software packages trying to use pgxs, for example.
Any ideas how to solve this?
Use /usr/lib/postgresql/$version/bin/pg_config, and adapt your
extension's Makefile to target that. For example with the following in
the Makefile:
PG_CONFIG ?= pg_config
And the call like this from debian/rules or elsewhere:
make PG_CONFIG=/usr/lib/postgresql/$version/bin/pg_config
I'm preparing some tools to automate all this for debian packaging
extensions, see the following:
http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/2010-January/000546.html
Regards,
--
dim
Adam Matan <adam@linqmap.com> writes:
I'm using postgresql 8.3 in my Ubuntu 8.04 dekstop computer. I have tried to
install postgresql 8.4 for some testing, and removed it afterwards
using *apt-get purge*.
But still, pg_config remains with the removed version, after postresql
restart and even total reboot:
You would need to take that up with whoever packages Postgres for
Ubuntu. It sounds like they have some glitch in the package setup.
AFAIK, whoever that is doesn't read this list, which is mainly for
upstream Postgres development.
regards, tom lane
Tom Lane <tgl@sss.pgh.pa.us> writes:
You would need to take that up with whoever packages Postgres for
Ubuntu. It sounds like they have some glitch in the package setup.
AFAIK, whoever that is doesn't read this list, which is mainly for
upstream Postgres development.
I think Martin Pitt reads this list, he's maintaining both for ubuntu
and debian. The problem itself is tied to the multi-major version
support in the packaging, and in the tools.
# dpkg -S /usr/bin/pg_config
libpq-dev: /usr/bin/pg_config
The libpq-dev should be independant of the major version you target, but
contains pg_config. Using the direct path works too:
postgresql-server-dev-8.4: /usr/lib/postgresql/8.4/bin/pg_config
postgresql-server-dev-8.3: /usr/lib/postgresql/8.3/bin/pg_config
You could even adjust your PATH to prepend it with the bin tools you
need for a specific debian major.
Regards,
--
dim