On Fri, 2011-05-06 at 20:23 +0200, Stefan Keller wrote: > Hi, > > 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 > switzerland.osm.bz2 > > 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?
I encountered the same problem when doing a similar upgrade yesterday. I managed to resolve it but I have not gone back to figure out exactly what causes it. The machine originally had both the system geos library in /usr and a custom compiled one in /usr/local. To resolve the problem I made sure I erased all traces of the system geos library and header files. Then did a 'make clean && make' cycle and it started working correctly. I did a few steps to try to figure out where it was going wrong and identified that the getSize() call in build_geometry.cpp is always returning 0. This causes all of the line & polygons geometries to be discarded. I have a suspicion this is triggered when using the headers from one version of geos and then linking against a different library version but I can not prove this yet. Jon _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
