This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

osm2pgsql - type “geometry” does not exist

I've only used osm2pgsql a few times with files from downloads.geofabrik.de and I've never run into a problem.

Today, I downloaded a PDF file from geofabrik (165 MB), created an empty databse in postgresql, and tried running it through osm2pgsql. This is the only output that I get...

C:\AKH_Maps\osm2pgsql>osm2pgsql -c -d gisdb-mi -U postgres -W -H localhost -S C:\AKH_Maps\osm2pgsql\default.style C:\AKH_Maps\GIS-sources\geofabrik\michigan-latest.osm.pbf
2020-12-09 21:05:16  osm2pgsql version 1.4.0

Password:

2020-12-09 21:05:22  Database version: 12.1
2020-12-09 21:05:22  Node-cache: cache=800MB, maxblocks=12800*65536, allocation method=1
2020-12-09 21:05:23  Setting up table 'planet_osm_point'
2020-12-09 21:05:23  node cache: stored: 0(0.00%), storage efficiency: 0.00% (dense blocks: 0, sparse nodes: 0), hit rate: 0.00%
2020-12-09 21:05:23  [1m[38;2;255;000;000mERROR: [0m[1m[38;2;255;000;000mDatabase error: ERROR:  type "geometry" does not exist
LINE 1: ... text,"width" text,"wood" text,"z_order" int4,way geometry(P...
                                                             ^
[0m

Any idea what the problem is?

postgresql osm2pgsql geofabrik

asked 10 Dec '20, 03:37

AndrewNDeBear
11●1●1●3
accept rate: 0%

One Answer:

You forgot to run the PostgreSQL command CREATE EXTENSION postgis (or enable the PostGIS extension in another way).

answered 10 Dec '20, 08:45

Frederik Ramm ♦
82.5k●92●720●1273
accept rate: 23%

Yup. That was it.

2020-12-10 08:57:23  Osm2pgsql took 129s (2m 9s) overall.

Thanks!

alt text

(10 Dec '20, 14:05) AndrewNDeBear