[Tile-serving] [osm2pgsql] Problem during uploading OSM data to POSTGIS 2.1 (#459)

[Amrizhan]

Thanks, pnorman. i added postgis extension and now i got new error:


C:\geodata>osm2pgsql KZ.osm.pbf -d osm -U postgres -P 5432 -S default.style --hstore
osm2pgsql SVN version 0.69-21289M

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
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...
                                         ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.

Error occurred, cleaning up

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/459#issuecomment-147990895
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20151014/f82972d6/attachment.html>