[Tile-serving] [openstreetmap/osm2pgsql] loading to the database hangs both in Ubuntu 22.04 (wsl2) and windows 11 (Issue #1956)

[Jochen Topf]

You can try figuring out what it is doing after the last message appears using `ps` or `top` for the processes (or whatever the windows equivalent is) and using `SELECT * FROM pg_stat_activity;` in the database. I recommend keeping the `--number-processes=1` to keep things simpler.

You can also try to run osm2pgsql using the flex backend and disabling the cluster step. See `https://osm2pgsql.org/doc/manual.html#advanced-table-definition` for how to disable clustering. You can use the `flex-config/simple.lua` as starting point. Maybe this will tell us something.

There is also the `--log-sql` command line option which shows which SQL commands osm2pgsql is trying to run, but that generated a lot of output and I am not sure it will tell us anything useful.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1956#issuecomment-1534776070
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/issues/1956/1534776070 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20230504/7887b9ee/attachment.htm>