[OSM-dev] osm2pgsql: missing osm_polygon and osm_line data under PostgreSQL 9/PostGIS 1.5.2
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
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