AW: [postgis-devel] could not load library /usr/lib/postgresl/lib lwgeom.so.1.1

[TECHER David]

Hi

Is /usr/lib/postgresql in your file /etc/ld.so.conf ???

If it is not the case, as root do

echo /usr/lib/postgresql >> /etc/ld.so.conf

ldconfig -v

su postgres

dropdb yourdb
createdb yourdb
createlang plpgsql yourdb
psql -d yourdb -f $(find $(pg_config --bindir)/.. | grep lwpostgis.sql)
psql -d yourdb -f $(find $(pg_config --bindir)/.. | grep
spatial_ref_sys.sql)


BIBIS, Bohnebeck, Uta a écrit :

>>It looks like you compiled postgis against the wrong set of PostgreSQL
>>    
>>
>headers, can this be the case ?
>May be. 
>I'm not a Unix/Linux profi and I strictly followed the installation
>instructions (short version) 
>of PostgreSQL and then of PostGIS.
>
>  
>
>>Last lines of ./configure should tell you what pg_config you're using. 
>>pg_config --includedir-server is what's used to find postgres.h
>>    
>>
>
>After running ./configure I got the following output:
>SUMMARY
> -------------------------------------------------------
>
> HOST_OS: linux-gnu
>
>   PGSQL: /usr/bin/pg_config
>   ICONV: 1
>
> PORTNAME: linux
>   PREFIX: /usr
>  EPREFIX: ${prefix}
>      DOC: /usr/share/doc/packages/postgresql/contrib
>     DATA: /usr/share/pgsql/contrib
>      MAN: /usr/share/man
>      BIN: /usr/bin
>      EXT: /usr/lib/postgresql (\$$libdir)
> -------------------------------------------------------
>
>
>
>-----Ursprüngliche Nachricht-----
>Von: strk at refractions.net [mailto:strk at refractions.net]
>Gesendet: Mittwoch, 8. Februar 2006 13:43
>An: 'postgis-devel at postgis.refractions.net'
>Betreff: Re: [postgis-devel] could not load library
>/usr/lib/postgresl/liblwgeom.so.1.1
>
>
>It looks like you compiled postgis against the wrong set
>of PostgreSQL headers, can this be the case ?
>Last lines of ./configure should tell you what
>pg_config you're using. pg_config --includedir-server
>is what's used to find postgres.h
>
>--strk;
>
>On Wed, Feb 08, 2006 at 01:39:43PM +0100, BIBIS, Bohnebeck, Uta wrote:
>  
>
>>Hello,
>>I have installed postgresql (version 8.1.2) and are now trying to install
>>postgis (version 1.1.1) on a linux machine
>>and receive the following error message:
>>
>>contrib/postgis-1.1.1> psql -U postgres -d test -f lwpostgis.sql
>>BEGIN
>>psql:lwpostgis.sql:45: NOTICE:  type "histogram2d" is not yet defined
>>psql:lwpostgis.sql:45: ERROR:  could not access file
>>"$libdir/liblwgeom.so.1.1": No such file or directory
>>psql:lwpostgis.sql:50: ERROR:  current transaction is aborted, commands
>>ignored until end of transaction block
>>...
>>
>>After modifying the variable $libdir to the path /usr/lib/postgresql
>>the file was found but nethertheless the library is not loaded.
>>
>>contrib/postgis-1.1.1> psql -U postgres -d test -f lwpostgis.sql
>>BEGIN
>>psql:lwpostgis.sql:45: NOTICE:  type "histogram2d" is not yet defined
>>psql:lwpostgis.sql:45: ERROR:  could not load library
>>"/usr/lib/postgresql/liblwgeom.so.1.1":
>>/usr/lib/postgresql/liblwgeom.so.1.1: undefined symbol: nth
>>psql:lwpostgis.sql:50: ERROR:  current transaction is aborted, commands
>>ignored until end of transaction block
>>...
>>
>>Any ideas to solve this problems?
>>
>>Best regards,
>>Uta 
>>
>>
>>_______________________________________________
>>postgis-devel mailing list
>>postgis-devel at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>    
>>
>
>  
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20060208/4c77e13f/attachment.html>