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

[Bayu Kurniawan R]

make sure your GEOS compilation is right,
compile GEOS by typing
./configure
make
make install
Make sure that /usr/local/lib is added to /etc/ld.so.conf
Make sure that you run /sbin/ldconfig afterwards


On 7/23/07, caij at lreis.ac.cn <caij at lreis.ac.cn> wrote:
>
> 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.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Bayu Kurniawan R
GIS Programmer
PT. Sigma Cipta Utama
Jl. Tekno I Blok B No:5,6,7
BSD City Tangerang 15314
Phone : +62 21 75871955 ext.172
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070723/655c5a8c/attachment.html>