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

[Tim Bowden]

On Tue, 2008-01-08 at 23:23 +0100, Sebastien ARBOGAST wrote:
> 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
> ...
> 

My French is not so good but put /usr/local/pgsql/lib in /etc/ld.so.conf
(or /etc/ld.so.conf.d/<filename>.conf depending on distribution) and
then run ldconfig.  That may solve the issue.

Regards,
Tim Bowden

> 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.
>