[postgis-users] postgis-1.1.3:psql lwpostgis.sql problem

caij at lreis.ac.cn caij at lreis.ac.cn
Sun Jul 22 19:26:02 PDT 2007


Hi all,
i'm trying to install PostGIS 1.1.2
 over PostgreSQL 8.1.9
 on Linux

 the steps
 - make
 - make install

 are OK

 but when run
 psql -f lwpostgis.sql -d mydb

 had the following result :

 "
  BEGIN
 psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:45: NOTICE:
type
 "histogram2d" is not yet defined
 DETAIL:  Creating a shell type definition.
 psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:45: ERROR:
could
 not load library "/usr/local/postgresql8_1_3/pgsql/lib/liblwgeom.so":
Cannot
 run a file that does not have a valid format.
 psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:50: ERROR:
 current transaction is aborted, commands ignored until end of transaction
 block
 psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:58: ERROR:
 current transaction is aborted, commands ignored until end of transaction
 block
 ...
 ...
 ...
 psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:3358: ERROR:
 current transaction is aborted, commands ignored until end of transaction
 block
 ROLLBACK

 "
 Many thanks to anybody that can help me.





More information about the postgis-users mailing list