“Geometry” Problem while creating Postgis database on Ubuntu

Question

I am trying to build pgrouting on ubuntu. Therefore, I now firstly try to create a Postgis database on ubuntu.

I am following the instructions on this site:

Installing PostGIS 1.5 on PostgreSQL 8.4 on Ubuntu

I have installed postgresql and postgis.

I now try to run the necessary sql queries: psql -d my_db -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql

However, I got an error as shown in the screenshot below:

http://postimage.org/image/ggk7xg17p/

It looks like there is a problem with the query as -it firstly aborts the transactions continuously and -then says type "geometry", "box2d", "geometry" cannot be found

I was expecting these variables to occur as a result of this query. Why am I getting such an error while running the query?

Any idea would be more than welcome.

Thanks!

---

I checked the first error I get on this action:

ERROR Could not access the file "$libdir/postgis-1.5": No such file or directory

I have been checking on Google but not so useful yet. Any idea to fix it?

Answer 1

i think you have to check your GEOS - (Geometry Engine - Open Source) version. Box Types and Geometries mostly make the problem with old version of GEOS Library...

you can learn your GEOS version from PostGIS with this way :

postgres=# select PostGIS_full_version();
postgis_full_version                                                                  
-------------------------------------------------------------------------------
POSTGIS="2.0.0alpha4SVN" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.7.1,
7 September 2011" GDAL="GDAL 1.8.1, released 2011/07/09" LIBXML="2.7.3" USE_STATS
(1 row)

in addition to this you can check this answer...

i hope it helps you...