[Gfoss] Aiuto postgres-postgis

[Pietro]

Ciao a voi
scusate se vi tedio, ma ogni tanto provo a mettermi a configurare Ubuntu 
per usarlo con i vari pacchetti GIS, ci provo...

Ho provato a configurare Postgres e Postgis per la creazione dei geodb, 
scaricandoli dai repo di Ubuntu (7.10).
Installati (postgres 8.2.5) e postgis (1.2.1-2)+postgres-8.2-postgis 
(1.2.1-2).

L'utente postgres esiste e ho creato una password che mi viene accettata.

Ho fatto 1 cartella di prova ed ho creato un db di prova (pippo), solo 
che quando provo a caricare le funzioni di postgis mi dà errori...
tipo (taglio pezzi ripetuti):
postgres a pieri-laptop:/home/pieri$ psql -d pippo -f 
/usr/share/postgresql-8.2-postgis/lwpostgis.sql
BEGIN
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:43: NOTICE:  type 
"histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:48: NOTICE:  
argument type histogram2d is only a shell
CREATE FUNCTION
CREATE TYPE
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:73: NOTICE:  type 
"spheroid" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:78: NOTICE:  
argument type spheroid is only a shell
CREATE FUNCTION
CREATE TYPE
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:102: NOTICE:  type 
"geometry" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:107: NOTICE:  
argument type geometry is only a shell
CREATE FUNCTION
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:120: NOTICE:  
return type geometry is only a shell
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:125: NOTICE:  
argument type geometry is only a shell
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION

++++++++++++
continua
++++++++++++
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:236: NOTICE:  type 
"box3d" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:241: NOTICE:  
argument type box3d is only a shell
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:295: NOTICE:  type 
"chip" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:300: NOTICE:  
argument type chip is only a shell
CREATE FUNCTION
CREATE TYPE
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:326: NOTICE:  type 
"box2d" is not yet defined
DETAIL:  Creating a shell type definition.
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:331: NOTICE:  
argument type box2d is only a shell
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION

++++++++++++++++
continua
++++++++++++++CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE AGGREGATE
CREATE FUNCTION
CREATE AGGREGATE
CREATE FUNCTION
CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1261: ERROR:  il 
linguaggio "plpgsql" non esiste
HINT:  Use CREATE LANGUAGE to load the language into the database.
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1269: ERROR:  
current transaction is aborted, commands ignored until end of 
transaction block
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1277: ERROR:  
current transaction is aborted, commands ignored until end of 
transaction block
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1284: ERROR:  
current transaction is aborted, commands ignored until end of 
transaction block
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1291: ERROR:  
current transaction is aborted, commands ignored until end of 
transaction block
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1310: ERROR:  
current transaction is aborted, commands ignored until end of 
transaction block

Un blocco...
Che può essere??

Avete una guida per niubboni??

Grazie per l'aiuto
pietro