<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE></TITLE>
<META content="MSHTML 6.00.2800.1515" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><SPAN class=163162014-08022006><FONT face=Courier color=#0000ff
size=2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=163162014-08022006><FONT color=#0000ff><FONT face=Courier><FONT
size=2><FONT color=#000000>> Is /usr/lib/postgresql in your file
/etc/ld.so.conf ???</FONT><BR>no, it was not in the file and I carried
out your commands successfully.</FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=163162014-08022006></SPAN> </DIV>
<DIV><SPAN class=163162014-08022006><FONT face=Courier color=#0000ff size=2>But
loading the library produces a similar error as before:</FONT></SPAN></DIV>
<DIV><SPAN class=163162014-08022006><FONT face=Courier color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=163162014-08022006><FONT color=#0000ff><A
href="mailto:postgres@bibis:/etc"><FONT face=Courier
size=2>postgres@bibis:/etc</FONT></A><FONT face=Courier size=2>> psql
-d test -f$(find $(pg_config --bindir)/.. | grep lwpostgis.sql)<BR>find:
/usr/bin/../lib/R/library/limma/doc: Permission denied<BR>find:
/usr/bin/../lib/R/library/statmod/doc: Permission denied<BR>find:
/usr/bin/../lib/man-db: Permission denied<BR>find:
/usr/bin/../share/snmp/snmpconf/snmptrapd.conf: Permission denied<BR>find:
/usr/bin/../share/snmp/snmpconf/snmpd.conf: Permission denied<BR>find:
/usr/bin/../share/snmp/snmpconf/snmp.conf: Permission denied<BR>find:
/usr/bin/../share/snmp/snmpconf/snmpconf.dir: Permission
denied<BR>BEGIN<BR>psql:/usr/bin/../share/pgsql/contrib/lwpostgis.sql:45:
NOTICE: type "histogram2d" is not yet
defined<BR>psql:/usr/bin/../share/pgsql/contrib/lwpostgis.sql:45: ERROR:
could not load library "/usr/lib/postgre<BR>sql/liblwgeom.so.1.1":
/usr/lib/postgresql/liblwgeom.so.1.1: undefined symbol:
nth<BR>psql:/usr/bin/../share/pgsql/contrib/lwpostgis.sql:50: ERROR:
current transaction is aborted, commands<BR> ignored until end of
transaction block<BR></FONT></FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Ursprüngliche Nachricht-----<BR><B>Von:</B> TECHER David
[mailto:davidtecher@yahoo.fr]<BR><B>Gesendet:</B> Mittwoch, 8. Februar 2006
15:06<BR><B>An:</B> PostGIS Development Discussion<BR><B>Betreff:</B> Re: AW:
[postgis-devel] could not load library /usr/lib/postgresl/lib
lwgeom.so.1.1<BR><BR></FONT></DIV>Hi<BR><BR>Is /usr/lib/postgresql in your
file /etc/ld.so.conf ???<BR><BR>If it is not the case, as root do<BR><BR>echo
/usr/lib/postgresql >> /etc/ld.so.conf<BR><BR>ldconfig -v<BR><BR>su
postgres<BR><BR>dropdb yourdb<BR>createdb yourdb<BR>createlang plpgsql
yourdb<BR>psql -d yourdb -f $(find $(pg_config --bindir)/.. | grep
lwpostgis.sql)<BR>psql -d yourdb -f $(find $(pg_config --bindir)/.. | grep
spatial_ref_sys.sql)<BR><BR><BR>BIBIS, Bohnebeck, Uta a écrit :
<BLOCKQUOTE cite=midBF52B6AA9196D71195C80030052FDA9D654F10@TTZBN
type="cite"><BLOCKQUOTE type="cite"><PRE wrap="">It looks like you compiled postgis against the wrong set of PostgreSQL
</PRE></BLOCKQUOTE><PRE wrap=""><!---->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.
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">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
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
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: <A class=moz-txt-link-abbreviated href="mailto:strk@refractions.net">strk@refractions.net</A> [<A class=moz-txt-link-freetext href="mailto:strk@refractions.net">mailto:strk@refractions.net</A>]
Gesendet: Mittwoch, 8. Februar 2006 13:43
An: '<A class=moz-txt-link-abbreviated href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</A>'
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:
</PRE>
<BLOCKQUOTE type="cite"><PRE wrap="">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
<A class=moz-txt-link-abbreviated href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</A>
<A class=moz-txt-link-freetext href="http://postgis.refractions.net/mailman/listinfo/postgis-devel">http://postgis.refractions.net/mailman/listinfo/postgis-devel</A>
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
</PRE></BLOCKQUOTE><BR></BLOCKQUOTE></BODY></HTML>