[postgis-users] psql:/usr/local/pgsql/share/lwpostgis.sql:44: ERREUR: Impossible d'accéder au fichier "$libdir/liblwgeom" : No such file or directory

[Sebastien ARBOGAST]

I'm trying to create a postgis template database on a postgis server I
just installed from source. I'm using postgresql-8.2.6 and
postgis-1.3.2.
But here is the log I get when I try to import lwpostgis.sql into my
template_postgis database:

$ psql -d template_postgis -f /usr/local/pgsql/share/lwpostgis.sql
BEGIN
psql:/usr/local/pgsql/share/lwpostgis.sql:44: NOTICE:  Taper
«histogram2d» n'est pas encore défini
DETAIL:  Création de la définition d'un shell type.
psql:/usr/local/pgsql/share/lwpostgis.sql:44: ERREUR:  Impossible
d'accéder au fichier "$libdir/liblwgeom" : No such file or directory
psql:/usr/local/pgsql/share/lwpostgis.sql:50: ERREUR:  La transaction
courante est annulée, les commandes sont ignorées jusqu'à la fon du
bloc de la transaction
...

This error seems to be very frequent but I couldn't find any thread on
a forum or mailing list where a final solution is suggested.

FYI, here is the summary I get from postgis configure and liblwgeom.so
is in /usr/local/pgsql/lib

SUMMARY
 -------------------------------------------------------

 HOST_OS: linux-gnu

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

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

Please help.

-- 
Sébastien Arbogast

http://www.sebastien-arbogast.com