[Gfoss] Aiuto postgres-postgis

Local Chapters GFOSS.it
1

Niente,
loggato come postgres e dato il comando che mi avete indicato (ora trovate pippodue come db, perchè ho anche provato a fare un dropdb e a crearne un altro, pippodue appunto)

pieri@pieri-laptop:~$ su postgres
Parola d'ordine:
postgres@pieri-laptop:/home/pieri$ psql -U postgres -d pippodueWelcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

pippodue=# create language plpgsql
pippodue-#

Questo è il nuovo output:

postgres@pieri-laptop:/home/pieri/provapgis/prova$ psql -d pippodue -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
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
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
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
************
snip
****************
CREATE AGGREGATE
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

e avanti..

Che può essere?

plpgsql è un linguaggio procedurale? (http://www.postgresql.org/docs/8.2/static/xplang-install.html)

Grazie di nuovo
riciao
p

2

Fatto!
non mi sono loggato nel db, ma l'ho fatto come utente postgres all'esterno del db

postgres@pieri-laptop:/home/pieri$ createlang plpgsql pippodue
postgres@pieri-laptop:/home/pieri$

postgres@pieri-laptop:/home/pieri$ psql -d pippodue -f /usr/share/postgresql-8.2-postgis/lwpostgis.sql

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
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
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
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

************************
snip
***********************

CREATE FUNCTION
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1339: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "spatial_ref_sys_pkey" for table "spatial_ref_sys"
CREATE TABLE
psql:/usr/share/postgresql-8.2-postgis/lwpostgis.sql:1357: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "geometry_columns_pk" for table "geometry_columns"
CREATE TABLE
CREATE FUNCTION

**********************
snip
*********************

CREATE FUNCTION
COMMIT

Ora dovrei riuscire a loggarmi con qgis al db?

Provo...
ciao
p

3

Ciao Pietro,
tempo fa ho scritto una pagina wiki (UbuntuGIS) su ubuntu-it.org
Due o tre giorni fa ho aggiornato le istruzioni per renderle adatte a Gutsy:

http://wiki.ubuntu-it.org/UbuntuGis

prova a seguirla, è molto semplice...

ciao

Alessio

Pietro ha scritto:

Niente,
loggato come postgres e dato il comando che mi avete indicato (ora trovate pippodue come db, perchè ho anche provato a fare un dropdb e a crearne un altro, pippodue appunto)

pieri@pieri-laptop:~$ su postgres
Parola d'ordine:
postgres@pieri-laptop:/home/pieri$ psql -U postgres -d pippodueWelcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

pippodue=# create language plpgsql
pippodue-#

Questo è il nuovo output:

postgres@pieri-laptop:/home/pieri/provapgis/prova$ psql -d pippodue -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
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
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
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
************
snip
****************
CREATE AGGREGATE
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

e avanti..

Che può essere?

plpgsql è un linguaggio procedurale? (http://www.postgresql.org/docs/8.2/static/xplang-install.html)

Grazie di nuovo
riciao
p

_______________________________________________
Iscriviti all'associazione GFOSS.it: http://www.gfoss.it/drupal/iscrizione
Gfoss@faunalia.com
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.

4

Ciao Alessio,
grazie del suggerimento e complimenti per la guida!!

Ieri sera smanettando sono riuscito a fare partire postgis-postgres e sono riuscito a caricare un paio di shp con spit di qgis.

Ora la prossima mossa è quella di installare ka-map e di fargli vedere i contenuti del geodb.

Nostra idea, ma siamo alle prime armi, è quella di fornire un sistema di navigazione di percorsi naturalistici in kayak agli utenti della nostra community

che trovi qui

www.canoafriuli.com

Vediamo, dai, con un po' di pazienza..

Bon, buona notte e grazie di nuovo

pietro

Alessio Di Lorenzo ha scritto:

Ciao Pietro,
tempo fa ho scritto una pagina wiki (UbuntuGIS) su ubuntu-it.org
Due o tre giorni fa ho aggiornato le istruzioni per renderle adatte a Gutsy:

http://wiki.ubuntu-it.org/UbuntuGis

prova a seguirla, è molto semplice...

ciao

Alessio