[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] postgis-1.1.3:psql lwpostgis.sql problem
From:       "Bayu Kurniawan R" <bayu () bkurniawan ! com>
Date:       2007-07-23 7:34:21
Message-ID: 45a45b1c0707230034o5fc65e03jf0ab3d6fe3dc00c8 () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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@lreis.ac.cn <caij@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@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

[Attachment #5 (text/html)]

make sure your GEOS compilation is right,<br>compile GEOS by \
typing<br>./configure<br>make <br>make install<br>Make sure that /usr/local/lib is \
added to /etc/ld.so.conf<br>Make sure that you run /sbin/ldconfig afterwards<br> \
<br><br><div><span class="gmail_quote">On 7/23/07, <b class="gmail_sendername"><a \
href="mailto:caij@lreis.ac.cn">caij@lreis.ac.cn</a></b> &lt;<a \
href="mailto:caij@lreis.ac.cn">caij@lreis.ac.cn</a>&gt; wrote:</span><blockquote \
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt \
0pt 0.8ex; padding-left: 1ex;"> Hi all,<br>i&#39;m trying to install PostGIS \
1.1.2<br> over PostgreSQL 8.1.9<br> on Linux<br><br> the steps<br> - make<br> - make \
install<br><br> are OK<br><br> but when run<br> psql -f lwpostgis.sql -d mydb<br><br> \
had the following result : <br><br> &quot;<br>&nbsp;&nbsp;BEGIN<br> \
psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:45: NOTICE:<br>type<br> \
&quot;histogram2d&quot; is not yet defined<br> DETAIL:&nbsp;&nbsp;Creating a shell \
type definition.<br> psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:45: \
ERROR: <br>could<br> not load library \
&quot;/usr/local/postgresql8_1_3/pgsql/lib/liblwgeom.so&quot;:<br>Cannot<br> run a \
file that does not have a valid format.<br> \
psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:50: ERROR: <br> current \
transaction is aborted, commands ignored until end of transaction<br> block<br> \
psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:58: ERROR:<br> current \
transaction is aborted, commands ignored until end of transaction <br> block<br> \
...<br> ...<br> ...<br> \
psql:/usr/local/postgresql8_1_3/pgsql/share/lwpostgis.sql:3358: ERROR:<br> current \
transaction is aborted, commands ignored until end of transaction<br> block<br> \
ROLLBACK<br><br> &quot; <br> Many thanks to anybody that can help \
me.<br><br><br>_______________________________________________<br>postgis-users \
mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
 </a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http: \
//postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br \
clear="all"><br>-- <br>Bayu Kurniawan R<br>GIS Programmer <br>PT. Sigma Cipta \
Utama<br>Jl. Tekno I Blok B No:5,6,7<br>BSD City Tangerang 15314<br>Phone : +62 21 \
75871955 ext.172



_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]