Following is the query : C:>osm2pgsql -c --slim -d osm_1 -U postgres -H localhost -S C:\default.style C:\mumbai_india.osm.pbf
Following is the error on which i am stuck:
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
Following is the version of osm2pgsql:
C:\>osm2pgsql osm2pgsql SVN version 0.69-21289M
I am using Windows 7 64bit PC with PostgreSql database installed with pgAdmin4.. I did pass various osm.pbf files in the above query but still getting the same issue. I went through various post and solutions and also created Extension postgis and Extension hstore in the database named osm_1 in pgAdmin4 postgresql but still the same issue..
I re-installed osm2pgsql with the latest version found on Google but still got the same error..