[ gpsdrive ] Trying to get osmdata

[Jannis Achstetter]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Kaare,

Kaare Rasmussen schrieb:
> Hi
> 
> Trying to install italy (and denmark) on an OpenSuse 11 installation from 
> http://download.geofabrik.de/osm/europe/ but I'm stuck with this error
> 
> ./osm2pgsql -v ~/Desktop/denmark.osm.bz2
> osm2pgsql SVN version 0.55-20081203 $Rev$
> 
> Using projection SRS 900913 (Spherical Mercator)
> Setting up table: planet_osm_point
> SELECT AddGeometryColumn('planet_osm_point', 'way', 900913, 'POINT', 2 );
>  failed: ERROR:  AddGeometryColumns() - invalid SRID
> CONTEXT:  SQL statement "SELECT AddGeometryColumn('','', $1 , $2 , $3 , $4 , 
> $5 )"
> PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
> 
> Error occurred, cleaning up
> 
> This is PostgreSQL 8.3.1 from OpenSuse, postgis from 
> http://download.opensuse.org/repositories/Application:/Geo/openSUSE_11.0 and 
> osm2pgsql from svn.
> 
> I would be happy if someone can guide me in the correct direction to solve 
> this error.
> 

This looks to like you forgot to install the "PostGIS"-extension to the
PostgreSQL-server. You need it to store OSM-data in your database.

Jannis
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkk22icACgkQeYlewm37lbjnjwCeL2eEiCAniEhB/ZK2Iqr8zm/L
2FsAnAgxrt1UbS/l5hWDrOx0Sk4YviRs
=ABt5
-----END PGP SIGNATURE-----