[OSM-talk] Cannot get osm2pgsql to run

Jon Burgess jburgess777 at googlemail.com
Wed Dec 10 00:15:09 GMT 2008

On Wed, 2008-12-10 at 00:33 +0100, Nop wrote:
> Hello!
> I am trying to set up a mapnik instance, but I cannot get osm2pgsql to 
> run. I have followed the instructions on 
> http://wiki.openstreetmap.org/wiki/Mapnik/PostGIS but they are rather 
> sketchy so I need some pointer on where the problem is.
> I have created a DB gis. First I got an error "missing function" so I 
> concluded that I had to create the db from the template_postgis, though 
> the Wiki does not mention this.

Copying the postgis template should not be needed, normally the postgis
extensions would be added to the DB in the step which mentions

> My user is superuser and owner of the 
> db. When I try to import a small osm file, I get the following error.
> osm2pgsql SVN version 0.55-20081113 $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:  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
> Can anybody tell what the problem is?

What version of PostgreSQL & PostGIS are you using? This is the first
time I have seen it fail like this.

The fix is probably to run:
$ psql gis
gis=> \i PATH/TO/.../export/osm2pgsql/900913.sql

This should add the 900913 SRID into the supported PostGIS projections


More information about the talk mailing list