Opened 12 years ago
Closed 12 years ago
#1035 closed defect (fixed)
osm2pgsql data loading fails at build time
Reported by: | kalxas | Owned by: | hamish |
---|---|---|---|
Priority: | major | Milestone: | OSGeoLive6.5 |
Component: | OSGeoLive | Keywords: | 6.5 |
Cc: | live-demo@… |
Description
NOTICE: table "planet_osm_point" does not exist, skipping NOTICE: table "planet_osm_point_tmp" does not exist, skipping PREPARE get_way (int4) AS SELECT AsText(way) FROM planet_osm_point WHERE osm_id = $1;
failed: ERROR: function astext(geometry) does not exist
LINE 1: PREPARE get_way (int4) AS SELECT AsText(way) FROM planet_osm...
Change History (16)
comment:1 by , 12 years ago
comment:2 by , 12 years ago
yes we need to rename the script because it gives the impression that PostGIS fails
comment:3 by , 12 years ago
Keywords: | alpha 4 removed |
---|---|
Summary: | data loading in PostGIS 2.0 fails at build time → osm2pgsql data loading fails at build time |
comment:4 by , 12 years ago
Owner: | changed from | to
---|
osm2pgsql v0.70 apparently is not compatible with PostGIS 2.0 - astext(geom) fails.. but this might be only one of many errors..
I am building osm2pgsql from svn now to test... version appears to be 0.81.
These are the packages I had to add to build osm2pgsql from source
autoconf libtool automake libxml2-dev libzip-dev libbz2-dev libgeos-dev libgeos++-dev postgresql-server-dev-9.1
comment:6 by , 12 years ago
perhaps there is a 0.8 stable release? (since svn seems to be at 0.81)
I found this package which is at 0.81. Perhaps we should change to this one. https://launchpad.net/~kakrueger/+archive/openstreetmap
There is a 0.80 update in the official ppa but not for 12.04 https://launchpad.net/ubuntu/+source/osm2pgsql
comment:8 by , 12 years ago
as a side note, the tool imposm
is the next generation of OSM import, is stable and is used with TileMill, for example. I see that there is already an imposm
package. Loading it requires an additional 600k for me.
I am adding imposm
to the installer, since it is required as we go forward with OpenStreetMap.
comment:9 by , 12 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Confirmed to work on build[9511]
comment:10 by , 12 years ago
Cc: | added |
---|---|
Priority: | critical → major |
Resolution: | fixed |
Status: | closed → reopened |
please move the ML email addr from the owner field if you take ownership of a ticket so it doesn't get lost
the version of osm2pgsql on the disc was custom built by me and stashed at http://download.osgeo.org/livedvd/data/osm/
see http://download.osgeo.org/livedvd/data/osm/osm2pgsql.README
If a new version is available great, let's use it, but we need to confirm that everything is up to date. this may or may not be responsible for gpsdrive's mapnik now failing.
not a blocker unless proven to be broken.
Hamish
comment:11 by , 12 years ago
Owner: | changed from | to
---|---|
Status: | reopened → new |
comment:13 by , 12 years ago
ah - good to see the actual osm2pgsql issue in the openstreetmap tracker.. this time it was perhaps uncharacteristically easy, as most users of PostGIS will have a couple of these pre ST_prefix calls sitting around in their, not just one.. but this issue resolution does show how straightforward it can be to port forward in PostGIS... as a matter of fact, those ST_ prefixes were introduced well before 2.0, in later 1.x versions.. people have been lagging in getting rid of those non-standard original calls for literally years! Its not that hard to do!
comment:14 by , 12 years ago
osm2pgsql is at version 0.81 on build 9640, so thats a GO as far as PostGIS 2.0
as noted in other tickets, there are two versions of libmapnik loaded, which is its own problem...
comment:16 by , 12 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
please note that this is specific to