<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=iso-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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>
</body>
</html>