Getting invalid stoi argument

[gulatidivyam]

I’m trying to import OSM PBF data into Azure PostgreSQL 17 on Windows 10 using osm2pgsql, but I keep getting this error:
Error: invalid stoi argument

Already tried classic mode with --hstore, fresh tables, and new --prefix
Would appreciate any advice/guidance.

[pnorman]

Can you please provide the exact command line, where we can get the tag transformed used, the source of the data, and the version of osm2pgsql?

[gulatidivyam]

Here is the exact command osm2pgsql --verbose --create --database osm --user osmdataloader -W -S "default.style" --output pgsql --host "xxxxx-postgres.postgres.database.azure.com" --hstore --hstore-add-index "I:\Apps\osm2pgsql-latest-x64\osm2pgsql-bin\europe-latest.osm.pbf" Have tried version 1.8.1 and 2.1.1 with data from geofabrik https://download.geofabrik.de/

[lonvia]

Please try with a recent master version of osm2pgsql, for example the one downloaded here. There are know issues with the ones generated from Windows-2019 images.

If that doesn't help, please provide the full output. We'd need to know when exactly the error happens.

[gulatidivyam]

Same error with the recent mater version. The error occurs pretty much immediately

C:\Users\xxxx\osm2pgsql-win64\osm2pgsql-bin>osm2pgsql -- verbose -- create -- database osm -user osmdataloader
-W -S "default. style" -output pgsql -- host "xxxxx-postgres. postgres. database. azure. com" -hstore -hstore-add-ind
ex "C:\Users\gud88r\Downloads\europe-latest. osm. pbf"
Password:

2025-08-14 15:48:26 osm2pgsql version 2.1.1
2025-08-14 15:48:26 [00] ERROR: invalid stoi argument

[joto]

Can you run this command in your database please: SELECT extversion from pg_catalog.pg_extension WHERE extname='postgis';

[gulatidivyam]

It returns

This is Azure PostgreSQL

[joto]

Okay. This explains the failure. I have no idea what Azure is doing there. It doesn't make any sense to not return a proper version number there. I suggest asking Azure support to fix that.

[pnorman]

It looks like you're not using PostgreSQL with PostGIS, but some Azure-specific fork that we don't support. If you can reproduce it with PostgreSQL we could look into it.

[joto]

There are two problems here:

One is the not very informative error "Error: invalid stoi argument". That has been fixed in 79bc89c. You should now get an error that the PostGIS version could not be detected.

The other is the problem that it seems Azure doesn't show a proper version numer. That's nothing we have any control over.