[Tile-serving] [openstreetmap/osm2pgsql] osm2pgsql stops while importing planet (#1115)

zimirrr notifications at github.com
Sat Apr 11 15:19:51 UTC 2020


I try to import full planet into postgresql with this command:
```
set tmpfile=flat-nodes
set osm_file=planet-200330.osm.pbf

osm2pgsql-latest\osm2pgsql.exe --create ^
 --number-processes 6 ^
 --cache 30000 ^
 --flat-nodes %tmpfile% ^
 --slim ^
 --drop ^
 --style osm2pgsql.style ^
 --hstore-all ^
 --latlong ^
 --multi-geometry ^
 --database %PGDATABASE% ^
 %osm_file%
```
I use windows 10 with latest updates, it has 128GB RAM.

DB is on another machine in same network.

osm2pgsql stops without any messages.
```
...
Reading in file: planet-200330.osm.pbf
Using PBF parser.
Processing: Node(5880134k 8317.0k/s) Way(182705k 48.75k/s) Relation(0 0.00/s)
```

In Event Viewer i see this msg:
```
Windows successfully diagnosed a low virtual memory condition. The following programs consumed the most virtual memory: osm2pgsql.exe (30400) consumed 175843065856 bytes,  javaw.exe (27024) consumed 3312525312 bytes
...
```

osm2pgsql
```
d:\temp\osm\osm2pgsql-latest>osm2pgsql.exe --version
osm2pgsql version 0.96.0 (64 bit id space)

Compiled using the following library versions:
Libosmium 2.15.1
Lua 5.3.4
```

I tried with different cache parameters, it always uses more memory than i set.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1115
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20200411/e52ec099/attachment.htm>


More information about the Tile-serving mailing list