Geographic Information Systems Asked by Radek on April 28, 2021
I started the full planet import, and after a week of work the job was ALMOST done, failed during building indexes after the import as the harddrive run out of space. Is there a way how I can just rebuild the indexes without reimporting the whole set?
Here is the log.
sudo -u renderer osm2pgsql -d gis --create --slim -G --hstore --tag-transform-script /home/renderer/src/openstreetm ap-carto/openstreetmap-carto.lua --number-processes 8 -S /home/renderer/src/openstreetmap-carto/openstreetmap-carto.s tyle /data.osm.pbf -C 32000 --flat-nodes /nodes/flat_nodes.bin
2021-01-30 17:39:17 osm2pgsql version 1.4.0
2021-01-30 17:39:17 Database version: 12.5 (Ubuntu 12.5-1.pgdg18.04+1)
2021-01-30 17:39:17 PostGIS version: 3.0
2021-01-30 17:39:17 Node-cache: cache=32000MB, maxblocks=512000*65536, allocation method=11
2021-01-30 17:39:17 Setting up table 'planet_osm_point'
2021-01-30 17:39:17 Setting up table 'planet_osm_line'
2021-01-30 17:39:17 Setting up table 'planet_osm_polygon'
2021-01-30 17:39:17 Setting up table 'planet_osm_roads'
2021-02-07 22:53:59 Reading input files done in 710082s (197h 14m 42s). 4/s)
2021-02-07 22:53:59 Processed 6634698177 nodes in 5524s (1h 32m 4s) - 1201k/s
2021-02-07 22:53:59 Processed 733743019 ways in 303789s (84h 23m 9s) - 2k/s
2021-02-07 22:53:59 Processed 8593984 relations in 400769s (111h 19m 29s) - 21/s
2021-02-07 22:54:00 Clustering table 'planet_osm_polygon' by geometry...
2021-02-07 22:54:00 Clustering table 'planet_osm_point' by geometry...
2021-02-07 22:54:00 Clustering table 'planet_osm_line' by geometry...
2021-02-07 22:54:00 Clustering table 'planet_osm_roads' by geometry...
2021-02-07 22:54:01 Building index on table 'planet_osm_ways'
2021-02-07 22:54:01 Building index on table 'planet_osm_rels'
2021-02-08 05:14:21 node cache: stored: 3812666007(57.47%), storage efficiency: 90.90% (dense blocks: 472519, sparse nodes: 161717496), hit rate: 56.10%
2021-02-08 05:14:24 ERROR: Database error: ERROR: could not extend file "base/16385/5832519.8": No space left on device
HINT: Check free disk space.
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP