[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[Pkg-grass-general] installing postgis

Hi all.
A friend tried to install the new postgis package, but it fails when starting 
lwpostgis.sql in the new db. I am attaching a report, in case it is useful 
for debugging.
All the best.
Installed packages:
    postgresql 7.4.7-3 
    libgeos2 2.0.1-1
    libpostgis1-pg74 1.0.0RC6-4 

template1=# CREATE DATABASE strade WITH TEMPLATE template_gis;
template1=# CREATE USER "strade" PASSWORD '****';
template1=# SELECT * FROM pg_user;
template1=# UPDATE pg_database SET datdba=100 WHERE datname='strade';

# su - postgres

$ createlang plpgsql strade
createlang: language "plpgsql" is already installed in database 

$ psql -f \
    /usr/share/postgresql/contrib/lwpostgis.sql strade

psql:/usr/share/postgresql/contrib/lwpostgis.sql:36: NOTICE:  
type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/share/postgresql/contrib/lwpostgis.sql:36: ERROR:  
could not load library 
/usr/lib/postgresql/lib/liblwgeom.so.1.0: undefined symbol: 
Paolo Cavallini
cavallini@faunalia.it   www.faunalia.it   www.faunalia.com
Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy   Tel: (+39)348-3801953

Reply to: