Skip to content

Instantly share code, notes, and snippets.

@sporkman
Created February 24, 2018 19:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sporkman/6829ef07576678c884119bb2ee4f3c01 to your computer and use it in GitHub Desktop.
Save sporkman/6829ef07576678c884119bb2ee4f3c01 to your computer and use it in GitHub Desktop.
setup log - luxembourg
2018-02-24 14:35:47 == WARNING: resetting threads to 1
2018-02-24 14:35:47 == Create DB
2018-02-24 14:35:47 == Setup DB
Postgres version found: 9.5
Postgis version found: 2.4
2018-02-24 14:35:51 == WARNING: external UK postcode table not found.
2018-02-24 14:35:52 == Import data
osm2pgsql version 0.93.0-dev (64 bit id space)
Using projection SRS 4326 (Latlong)
NOTICE: table "place" does not exist, skipping
Allocating memory for dense node cache
Allocating dense node cache in one big chunk
Allocating memory for sparse node cache
Sharing dense sparse
Node-cache: cache=842MB, maxblocks=13472*65536, allocation method=11
Mid: pgsql, cache=842
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Reading in file: /usr/home/nominatim/Nominatim-3.1.0/luxembourg-latest.osm.pbf
Using PBF parser.
^MProcessing: Node(190k 190.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)^MProcessing: Node(430k 215.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)^MProcessing: Node(670k 223.3k/s) Way(0k 0.00k/s) Relation(0 0.00/s)^MProcessing: Node(910k 227.5k/s) Way(0k 0.00k/s) Relation(0 0.00/s)^MProcessing: Node(1160k 232.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)^MProcessing: Node(1400k 233.3k/s) Way(0k 0.00k/s) Relation(0 0.00/s)^MProcessing: Node(1630k 232.9k/s) Way(0k 0.00k/s) Relation(0 0.00/s)^MProcessing: Node(1840k 230.0k/s) Way(0k 0.00k/s) Relation(0 0.00/s)^MProcessing: Node(1919k 240.0k/s) Way(17k 17.00k/s) Relation(0 0.00/s)^MProcessing: Node(1919k 240.0k/s) Way(49k 24.50k/s) Relation(0 0.00/s)^MProcessing: Node(1919k 240.0k/s) Way(99k 33.00k/s) Relation(0 0.00/s)^MProcessing: Node(1919k 240.0k/s) Way(150k 37.50k/s) Relation(0 0.00/s)^MProcessing: Node(1919k 240.0k/s) Way(203k 40.60k/s) Relation(0 0.00/s)^MProcessing: Node(1919k 240.0k/s) Way(248k 49.69k/s) Relation(40 40.00/s)^MProcessing: Node(1919k 240.0k/s) Way(248k 49.69k/s) Relation(1970 985.00/s) parse time: 15s
Node stats: total(1919866), max(5432026737) in 8s
Way stats: total(248439), max(563704809) in 5s
Relation stats: total(3245), max(8049606) in 2s
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels
Going over pending ways...
0 ways are pending
Using 1 helper-processes
^MFinished processing 0 ways in 0 s
Going over pending relations...
0 relations are pending
Using 1 helper-processes
^MFinished processing 0 relations in 0 s
Stopping table: planet_osm_nodes
Stopping table: planet_osm_ways
Stopping table: planet_osm_rels
Stopped table: planet_osm_nodes in 0s
Stopped table: planet_osm_ways in 0s
Building index on table: planet_osm_rels
Stopped table: planet_osm_rels in 0s
node cache: stored: 1919866(100.00%), storage efficiency: 49.91% (dense blocks: 3, sparse nodes: 1911000), hit rate: 100.00%
Osm2pgsql took 15s overall
2018-02-24 14:36:07 == Create Functions
NOTICE: type "addressline" does not exist, skipping
2018-02-24 14:36:07 == Create Tables
NOTICE: table "import_status" does not exist, skipping
NOTICE: table "import_osmosis_log" does not exist, skipping
NOTICE: table "word" does not exist, skipping
NOTICE: sequence "seq_word" does not exist, skipping
NOTICE: table "location_area" does not exist, skipping
NOTICE: table "location_property" does not exist, skipping
NOTICE: table "location_property_osmline" does not exist, skipping
NOTICE: table "search_name" does not exist, skipping
NOTICE: table "place_addressline" does not exist, skipping
NOTICE: table "placex" does not exist, skipping
NOTICE: sequence "seq_place" does not exist, skipping
NOTICE: table "location_postcode" does not exist, skipping
NOTICE: table "import_polygon_error" does not exist, skipping
NOTICE: table "import_polygon_delete" does not exist, skipping
NOTICE: sequence "file" does not exist, skipping
2018-02-24 14:36:07 == Recreate Functions
NOTICE: drop cascades to function get_addressdata(bigint,integer)
NOTICE: drop cascades to function get_wikipedia_match(hstore,character varying)
2018-02-24 14:36:07 == Create Partition Tables
NOTICE: type "nearplace" does not exist, skipping
NOTICE: type "nearfeature" does not exist, skipping
NOTICE: type "nearfeaturecentr" does not exist, skipping
NOTICE: table "search_name_blank" does not exist, skipping
2018-02-24 14:36:10 == Create Partition Functions
2018-02-24 14:36:10 == WARNING: wikipedia article dump file not found - places will have default importance
2018-02-24 14:36:10 == WARNING: wikipedia redirect dump file not found - some place importance values may be missing
2018-02-24 14:36:10 == Drop old Data
......................................................................................................................................................................................................................................................................
2018-02-24 14:36:12 == Loading word list
count
-------
22297
(1 row)
count
-------
1400
(1 row)
2018-02-24 14:36:17 == Load Data
................................................................
2018-02-24 14:37:22 == Reanalysing database
NOTICE: no non-null/empty features, unable to compute statistics
NOTICE: no non-null/empty features, unable to compute statistics
Latest data imported from 2018-02-23T19:50:28Z.
2018-02-24 14:37:25 == Calculate Postcodes
2018-02-24 14:37:28 == Index ranks 0 - 4
nominatim version 3.1.0
Starting indexing rank (0 to 4) using 1 threads
Starting rank 0
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 1
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 2
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 3
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 4
^M Done 0 in 0 @ 0.000000 per second - FINISHED
NOTICE: no non-null/empty features, unable to compute statistics
NOTICE: no non-null/empty features, unable to compute statistics
2018-02-24 14:37:30 == Index ranks 5 - 25
nominatim version 3.1.0
Starting indexing rank (5 to 25) using 1 threads
Starting rank 5
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 6
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 7
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 8
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 9
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 10
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 11
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 12
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 13
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 14
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 15
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 16
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 17
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 18
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 19
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 20
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 21
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 22
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 23
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 24
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 25
^M Done 0 in 0 @ 0.000000 per second - FINISHED
NOTICE: no non-null/empty features, unable to compute statistics
NOTICE: no non-null/empty features, unable to compute statistics
2018-02-24 14:37:32 == Index ranks 26 - 30
nominatim version 3.1.0
Starting indexing rank (26 to 30) using 1 threads
Starting rank 26
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 27
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 28
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 29
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting interpolation lines (location_property_osmline)
^M Done 0 in 0 @ 0.000000 per second - FINISHED
Starting rank 30
^M Done 0 in 0 @ 0.000000 per second - FINISHED
2018-02-24 14:37:32 == Index postcodes
2018-02-24 14:37:43 == Create Search indices
2018-02-24 14:37:44 == Create search index for default country names
getorcreate_country
---------------------
95326
(1 row)
getorcreate_country
---------------------
95327
(1 row)
count
-------
251
(1 row)
count
-------
247
(1 row)
count
-------
11688
(1 row)
Summary of warnings:
* resetting threads to 1
* external UK postcode table not found.
* wikipedia article dump file not found - places will have default importance
* wikipedia redirect dump file not found - some place importance values may be missing
2018-02-24 14:37:45 == Setup finished.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment