pg_config in libpq-dev is for 8.4.2 even though it's a dependency for 8.3

[William McVey]

Binary package hint: postgresql-8.4

I am following the instructions at http://geodjango.org/docs/install.html#ubuntudebian to try and install a platform to run a geodjango on.

I need postgis, which means I'm installing postgis and postgresql-8.3-postgis (as karmic does not seem to support postgis features with postgresql-8.4). However, postgis depends on libpq5 and libpq-dev includes pg_config which is associated with an 8.4.2 build, even though the actual postgresql server I have installed and running is postgresql 8.3. This causes problems in build scripts that reference 'pg_config --sysconfdir' when the directory that is needed is really /usr/share/postgresql/8.3/

ProblemType: Bug
Architecture: amd64
Date: Mon Jan 11 20:06:19 2010
DistroRelease: Ubuntu 9.10
Package: libpq-dev 8.4.2-0ubuntu9.10
ProcEnviron:
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-17.54-generic
SourcePackage: postgresql-8.4
Uname: Linux 2.6.31-17-generic x86_64

[Mike Taves (mwtoews)]

I have this problem with Hardy and a pure PostgreSQL 8.3 setup, and have determined the problem to be from libpq-dev from hardy-backports.

I've tested a clean server setup without hardy-backports enabled, and pg_config reports correct paths to 8.3 and version 8.3.9. It is only when the hardy-backports are enabled that it becomes messed up and reports to 8.4 (version 8.4.2). This breaks configurations to extensions, like PostGIS.

[nicopace (nicopace)]

i have removed both versions of postgresql, and left pg_config alone.
when i run pg_config, it still gives me information about the installed postgresql instance? :S
This is what it throws
#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=i486-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=i486-linux-gnu' 'CPPFLAGS='
CC = gcc
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
VERSION = PostgreSQL 8.4.2

Regards,