AW: AW: [postgis-devel] could not load library /usr/lib/postgresl /lib lwgeom.so.1.1
BIBIS, Bohnebeck, Uta
bohnebeck at ttz-Bremerhaven.de
Wed Feb 8 06:34:49 PST 2006
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>
More information about the postgis-devel
mailing list