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

[BIBIS, Bohnebeck, Uta]

Hi,
> Is /usr/lib/postgresql in your file /etc/ld.so.conf ???
no, it was not in the file and I carried out your commands successfully.
 
But loading the library produces a similar error as before:
 
 <mailto:postgres at bibis:/etc> postgres at bibis:/etc> psql -d test -f$(find
$(pg_config --bindir)/.. | grep lwpostgis.sql)
find: /usr/bin/../lib/R/library/limma/doc: Permission denied
find: /usr/bin/../lib/R/library/statmod/doc: Permission denied
find: /usr/bin/../lib/man-db: Permission denied
find: /usr/bin/../share/snmp/snmpconf/snmptrapd.conf: Permission denied
find: /usr/bin/../share/snmp/snmpconf/snmpd.conf: Permission denied
find: /usr/bin/../share/snmp/snmpconf/snmp.conf: Permission denied
find: /usr/bin/../share/snmp/snmpconf/snmpconf.dir: Permission denied
BEGIN
psql:/usr/bin/../share/pgsql/contrib/lwpostgis.sql:45: NOTICE:  type
"histogram2d" is not yet defined
psql:/usr/bin/../share/pgsql/contrib/lwpostgis.sql:45: ERROR:  could not
load library "/usr/lib/postgre
sql/liblwgeom.so.1.1": /usr/lib/postgresql/liblwgeom.so.1.1: undefined
symbol: nth
psql:/usr/bin/../share/pgsql/contrib/lwpostgis.sql:50: ERROR:  current
transaction is aborted, commands
 ignored until end of transaction block


-----Ursprüngliche Nachricht-----
Von: TECHER David [mailto:davidtecher at yahoo.fr]
Gesendet: Mittwoch, 8. Februar 2006 15:06
An: PostGIS Development Discussion
Betreff: Re: AW: [postgis-devel] could not load library
/usr/lib/postgresl/lib lwgeom.so.1.1


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>  [
mailto:strk at refractions.net <mailto:strk at refractions.net> ]

Gesendet: Mittwoch, 8. Februar 2006 13:43

An: ' postgis-devel at postgis.refractions.net
<mailto: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
<mailto:postgis-devel at postgis.refractions.net> 

http://postgis.refractions.net/mailman/listinfo/postgis-devel
<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/b1cb9e88/attachment.html>