[postgis-users] PostGIS Install Failure: make check, lwpostgis.sql, ... errors

[Stefan Oberhauser]

Hello,

I tried to install PostGIS 1.2.1 on Ubuntu 6.06 according to the
instructions on the PostGIS Homepage. Finally running "lwpostgis.sql"
didn't succeed after several errors just before.

What I did:

1) Install Proj (4.4.9), GEOS (2.1.4), PostgreSQL 8.1 from Ubuntu
Repository. (apt-get ...)

2)./configure --prefix=/usr --with-pgsql=/usr/bin/pg_config
--with-geos=/usr/bin/geos-config --with-proj=/usr

I got a suspicious warning:
 ...
config.status: WARNING:  Makefile.config.in seems to ignore the
--datarootdir setting

3) sudo make ... without error

4) make check:

make -C regress test
make[1]: Betrete Verzeichnis
'/usr/share/postgresql/8.1/contrib/postgis-1.2.1/regress'
Creating spatial db postgis_reg
ERROR:  function postgis_lib_version() does not exist
HINT:  No function matches the given name and argument types. You may
need to add explicit type casts.

 Something went wrong (no postgis installed in postgis_reg).
 For details, check /tmp/pgis_reg_8758/regress_log

make[1]: *** [test] Fehler 1
make[1]: Verlasse Verzeichnis
'/usr/share/postgresql/8.1/contrib/postgis-1.2.1/regress'
make: *** [check] Fehler 2
------------------

Content of file /tmp/pgis_reg_8758/regress_log:

CREATE DATABASE
BEGIN
psql:lwpostgis.sql:43: NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:lwpostgis.sql:43: ERROR:  could not load library
"/usr/share/postgresql/8.1/contrib/postgis-1.2.1/lwgeom/liblwgeom.so.1.2": /usr/share/postgresql/8.1/contrib/postgis-1.2.1/lwgeom/liblwgeom.so.1.2: undefined symbol: has_arc
psql:lwpostgis.sql:48: ERROR:  current transaction is aborted, commands
ignored until end of transaction block


5) Despite this, if I run "make install":

 ...
mv: Zugriff auf „/usr/bin/createdb.postgis“: Too many levels of symbolic
links
mv: Zugriff auf „/usr/bin/mktemplate_gis“: Too many levels of symbolic
links
mv: Zugriff auf „/usr/bin/rmtemplate_gis“: Too many levels of symbolic
links
 ...

(What means "Too many levels of symbolic links"?)

6) createdb mytestdb: runs without error.

7) createlang plpqsql mytestdb:
(Translation from German error message:)

createlang: Install of language failed: ERROR:  language »plpqsql« not
supported
HINT:  Supported languages are in system catalogue pg_pltemplate

(Where could I find this catalogue?)

8) If I try:
psql -f /usr/share/postgresql/8.1/contrib/postgis-1.2.1/lwpostgis.sql -d
mytestdb:
(Translation from German error message:)

psql:/usr/share/postgresql/8.1/contrib/postgis-1.2.1/lwpostgis.sql:4378:
ERROR:  current transaction is aborted, commands ignored until end of
transaction block.
ROLLBACK
--------------------------

I've got stuck with this. I've found some similar threads in the archive
but I need some additional hints.
Thank you very much if there is anybody who has an idea what I could try
to resolve this installation problem.

Kind regards,

Stefan Oberhauser
Cartographer
Austria