[ gpsdrive ] ERROR while running 'sudo -u osm /usr/bin/osm2pgsql --database

[carlo mecozzi]

on ubuntu 8.04.1 i386 I get This error launching mapnik-osm-updater.sh :

ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
----- Create Database-user 'osm'

----- Grant rights on Database 'gis' for 'osm'
ERROR:  la relazione "geometry_columns" non esiste
ERROR:  la relazione "spatial_ref_sys" non esiste
Create DB User for every USER
all_users: nobody
carlo
osm
	Create DB User for carlo
createuser: creation of new role failed: ERROR:  role "carlo" already
exists
-------- GRANT Rights to every USER
Granting rights to users: ' carlo'
Granting all rights to user 'carlo' for Database 'gis'
ERROR:  la relazione "geometry_columns" non esiste
ERROR:  la relazione "spatial_ref_sys" non esiste
ERROR:  la relazione "planet_osm_line" non esiste
ERROR:  la relazione "planet_osm_point" non esiste

--------- Unpack and import /home/osm/osm/planet/italy.osm.bz2
osm2pgsql SVN version 0.55-20080910 $Rev: 10464 $ 

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT',
2 );
 failed: ERROR:  la funzione addgeometrycolumn(unknown, unknown,
integer, unknown, integer) non esiste
LINE 1: SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, ...
               ^
HINT:  No function matches the given name and argument types. You might
need to add explicit type casts.

Error occurred, cleaning up
!!!!!!!! ERROR while running 'sudo -u osm /usr/bin/osm2pgsql --database
gis /home/osm/osm/planet/italy.osm.bz2'
Creation with for Database gis from planet-file
'/home/osm/osm/planet/italy.osm.bz2' with '/usr/bin/osm2pgsql' Failed
see Logfile for more Information:
less /var/log/osm2pgsql_postgis-gis.log
carlo at ubuntu-desktop:~$ 

this is /vat/log/osm2pgsql_postgis-gis.log

Import started: ven set 12 08:58:23 CEST 2008
ven set 12 08:58:24 CEST 2008: Import With Error 1:
-rw-r--r-- 1 root root 29785420 2008-09-12
04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
Import started: ven set 12 09:04:27 CEST 2008
ven set 12 09:04:27 CEST 2008: Import With Error 1:
-rw-r--r-- 1 osm root 29785420 2008-09-12
04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
Import started: ven set 12 09:06:42 CEST 2008
ven set 12 09:06:42 CEST 2008: Import With Error 1:
-rw-r--r-- 1 osm root 29785420 2008-09-12
04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
Import started: ven set 12 09:18:40 CEST 2008
ven set 12 09:18:40 CEST 2008: Import With Error 1:
-rw-r--r-- 1 osm root 29785420 2008-09-12
04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
Import started: ven set 12 13:47:37 CEST 2008
ven set 12 13:47:37 CEST 2008: Import With Error 1:
-rw-r--r-- 1 osm root 29785420 2008-09-12
04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)
Import started: ven set 12 13:50:37 CEST 2008
ven set 12 13:50:37 CEST 2008: Import With Error 1:
-rw-r--r-- 1 osm root 29785420 2008-09-12
04:51 /home/osm/osm/planet/italy.osm.bz2 import --> rc(1)


thanks