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

[Vitaly Zabavin]

<!-- Please don't use screenshots. Copy and paste the *text* output here if that's needed for context. -->

## What version of osm2pgsql are you using?
osm2pgsql version 1.8.1
<!-- Paste output of `osm2pgsql --version` here. Please use the [latest
release](https://osm2pgsql.org/releases/) of osm2pgsql if at all
possible. -->



## What operating system and PostgreSQL/PostGIS version are you using?
PostgreSQL 15.2 (Ubuntu 15.2-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04) 11.3.0, 64-bit
<!-- Also what Linux distribution if applicable, OS version? -->
Welcome to Ubuntu 22.04.2 LTS (GNU/Linux 4.4.0-22621-Microsoft x86_64) (WSL2) on
Microsoft Windows [Version 10.0.22621.1555]

## Tell us something about your system
 
CPU	Intel(R) Core(TM) i7-10750H CPU @ 2.60GHz   2.59 GHz
RAM	32,0 ГБ (доступно: 31,9 ГБ)
SysType	64 CPU x64
 
name Windows 11 Pro
 ver 22H2
.build ОС	22621.1555
Windows Feature Experience Pack 1000.22640.1000.0


<!-- How much RAM do you have, how many CPUs, bare metal or cloud setup? -->
osm2pgsql -d iaddr -H localhost -P 5432 -U postgres --proj 4326 -W -C32000 -p kz -S d:\osm\osm2pgsql\default.style  d:\osm\kz.pbf

## What did you do exactly?
osm2pgsql -d iaddr -H localhost -P 5432 -U postgres --proj 4326 -W -C32000 -p kz -S d:\osm\osm2pgsql\default.style  d:\osm\kz.pbf

<!-- Please provide the command(s) you used including all options etc. Include
links to input files. --> 

## What did you expect to happen?
2023-05-04 09:00:29 Database version: 15.2 (Ubuntu 15.2-1.pgdg22.04+1)
2023-05-04 09:00:29 PostGIS version: 3.3
2023-05-04 09:00:30 Setting up table 'kz_point'
2023-05-04 09:00:30 Setting up table 'kz_line'
2023-05-04 09:00:30 Setting up table 'kz_polygon'
2023-05-04 09:00:30 Setting up table 'kz_roads'
2023-05-04 09:00:54 Reading input files done in 24s.
2023-05-04 09:00:54 Processed 24390731 nodes in 1s - 24391k/s
2023-05-04 09:00:54 Processed 2939690 ways in 19s - 155k/s
2023-05-04 09:00:54 Processed 12711 relations in 4s - 3k/s
2023-05-04 09:00:54 Clustering table 'kz_line' by geometry...
2023-05-04 09:00:54 Clustering table 'kz_point' by geometry...
2023-05-04 09:00:54 Clustering table 'kz_polygon' by geometry...
2023-05-04 09:00:54 Clustering table 'kz_roads' by geometry...
<!-- Describe in detail what you expected the above would do. -->


## What did happen instead?
loading to the database hangs both in Ubuntu 22.04 (wsl2) and windows 11
on punct
 2023-05-04 09:00:54 Clustering table 'kz_roads' by geometry... 

<!-- Please describe what happened and why you think this is wrong. Please include
(or link to, if it is too verbose) the log output. -->


## What did you do to try analyzing the problem?
changed pbf style 
<!-- Describe what steps you already did to try analyzing the problem before
reporting. -->



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

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