[postgis-users] Incorrect installation path on Linux?

[Mateusz Loskot]

Hi,

I suppose there is something wrong with configuration of 'make install'
target
in latest postgis-1.3.1.
I use Linux (latest Ubuntu) + PostgreSQL 8.2.4 and I followed the
official installation guidelines.

Here is my summary from the ./configure script:

-------------------------------------------------------
mloskot at dog:~/src/postgresql-8.2.4/contrib/postgis-1.3.1$ ./configure
...
 HOST_OS: linux-gnu

   PGSQL: /usr/bin/pg_config
    GEOS: /usr/local/bin/geos-config (with C-API)
          (ldflags: -L/usr/local/lib)
    PROJ: prefix=/usr libdir=/usr/lib
   ICONV: 1

 PORTNAME: linux
   PREFIX: /usr
  EPREFIX: ${prefix}
      DOC: /usr/share/doc/postgresql-doc-8.2/contrib
     DATA: ${datarootdir}
      MAN: ${datarootdir}/man
      BIN: /usr/lib/postgresql/8.2/bin
      EXT: /usr/lib/postgresql/8.2/lib (\$$libdir)
-------------------------------------------------------

Here is output from the pg_config:

-------------------------------------------------------
postgres at dog:~$ pg_config
BINDIR = /usr/lib/postgresql/8.2/bin
DOCDIR = /usr/share/doc/postgresql-doc-8.2
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/8.2/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql/8.2/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/8.2/man
SHAREDIR = /usr/share/postgresql/8.2
SYSCONFDIR = /etc/postgresql
PGXS = /usr/lib/postgresql/8.2/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.2' '--disable-maintainer-mode'
'--disable-dependency-tracking' '--srcdir=.'
'--mandir=/usr/share/postgresql/8.2/man'
'--with-docdir=/usr/share/doc/postgresql-doc-8.2'
'--datadir=/usr/share/postgresql/8.2'
'--bindir=/usr/lib/postgresql/8.2/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-openssl' '--with-gnu-ld'
'--with-tclconfig=/usr/lib/tcl8.4' '--with-tkconfig=/usr/lib/tk8.4'
'--with-includes=/usr/include/tcl8.4' '--with-pgport=5432' 'CFLAGS=-g
-Wall -O2 -fPIC' 'LDFLAGS=-Wl,--as-needed' 'CC=cc' 'CPPFLAGS='
'build_alias=i486-linux-gnu'
CC = cc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/tcl8.4
CFLAGS = -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith
-Winline -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing -g
CFLAGS_SL = -fpic
LDFLAGS = -Wl,--as-needed
LDFLAGS_SL =
LIBS = -lpgport -lpam -lssl -lcrypto -lkrb5 -lcom_err -lz -lreadline
-lcrypt -ldl -lm
VERSION = PostgreSQL 8.2.4
-------------------------------------------------------

As you see, the SHAREDIR is correctly defined.

It *seems* this setting is ignored by 'make install' and PostGIS stuff
goes to wrong place:

-------------------------------------------------------
mloskot at dog:~/src/postgresql-8.2.4/contrib/postgis-1.3.1$ make install
...
/home/mloskot/src/postgresql-8.2.4/contrib/postgis-1.3.1/install-sh -c
-m 644 ../lwpostgis.sql /usr/share/lwpostgis.sql
/home/mloskot/src/postgresql-8.2.4/contrib/postgis-1.3.1/install-sh -c
-m 644 ../lwpostgis_upgrade.sql /usr/share/lwpostgis_upgrade.sql
/home/mloskot/src/postgresql-8.2.4/contrib/postgis-1.3.1/install-sh -c
-m 644 ../spatial_ref_sys.sql /usr/share/spatial_ref_sys.sql
...
-------------------------------------------------------

Here you can see installation result:

mloskot at dog:~$ ls /usr/share/lwpostgis*
/usr/share/lwpostgis.sql  /usr/share/lwpostgis_upgrade.sql

mloskot at dog:~$ ls /usr/share/postgresql/8.2/lwpostgis*
ls: /usr/share/postgresql/8.2/lwpostgis*: No such file or directory
mloskot at dog:~/src/postgresql-8.2.4/contrib/postgis-1.3.1$


Am I doing anything wrong or there is a bug or everything is correct
and the PostGIS scripts should live outside PostgreSQL installation tree?

Best regards
-- 
Mateusz Loskot
http://mateusz.loskot.net