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): [EMAIL PROTECTED]:/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 _______________________________________________ Iscriviti all'associazione GFOSS.it: http://www.gfoss.it/drupal/iscrizione [email protected] http://www.faunalia.com/cgi-bin/mailman/listinfo/gfoss 281 iscritti al 26.11.2007 Questa e' una lista di discussione pubblica aperta a tutti. I messaggi di questa lista non rispecchiano necessariamente le posizioni dell'Associazione GFOSS.it.
