[OSM-dev] osm2pgsql: missing osm_polygon and osm_line data under PostgreSQL 9/PostGIS 1.5.2

Stefan Keller sfkeller at gmail.com
Fri May 6 19:23:33 BST 2011


We recently upgraded to PostgreSQL 9 and PostGIS 1.5.2 and hence were
forced to rebuild osm2pgsql because of new versions of its
dependencies (e.g., libgeos).
Afterwards, we tried to insert Switzerland data with the following command:

$ osm2pgsql --create --database gisdb --prefix osm --style
/usr/local/share/osm2pgsql/default.style --username xxx --hstore-all

Unfortunately, only the osm_point table was filled with data,
osm_polygon and osm_line were empty. This was not the case before the
upgrade of the mentioned components. In the thread
http://forum.openstreetmap.org/viewtopic.php?id=10725 somebody
explained that this could be caused by multiple installations of
libgeos or due to old installations of this library which is silently
ignored by osm2pgsql and hence the tables will just not be filled.

On our machine, I verified that this is NOT the case:

$ ldd /usr/local/bin/osm2pgsql  | grep libgeos
    libgeos-3.2.2.so => /usr/lib/libgeos-3.2.2.so (0x00007f8485065000)

As one can see, there is only one version of the shared library that
is used and that one has the version we need.

Do you have any ideas what the problem could be?

Michael and Stefan

More information about the dev mailing list