NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hi guys! I try to upload a large pbf file(Netherland) from Geofabrik into Nominatim db (with small area import works fine). What I'm doing:

1)Start this script: ./utils/setup.php --osm-file maps/netherlands-latest.osm.pbf --all --osm2pgsql-cache 6000 2>&1 | tee /opt/Nominatim/setup.log

2) I'm waiting until proceess terminates unexpectedly. here pg_log file: http://pastebin.com/auzWXxbP Also I get errors in setup.log

CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF); failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Error occurred, cleaning up ERROR: Error executing external command: /opt/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C 6000 -P 5432 -d nominatim /opt/Nominatim/maps/netherlands-latest.osm.pbf Error executing external command: /opt/Nominatim/osm2pgsql/osm2pgsql -lsc -O gazetteer --hstore -C 6000 -P 5432 -d nominatim /opt/Nominatim/maps/netherlands-latest.osm.pbf ~

What am I doing wrong? is that hardware issue (mem 8Gb) or something else? Any ideas will be appreciated.

Update: pg_log: http://pastebin.com/CGSAchit it is crashed on "Failed process was running: CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF);" and I don't know what's going wrong with it.

asked 17 Jul '15, 10:34

Silentium's gravatar image

Silentium
9224
accept rate: 0%

edited 17 Jul '15, 13:03

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×689
×263
×165
×30

question asked: 17 Jul '15, 10:34

question was seen: 4,635 times

last updated: 17 Jul '15, 13:03

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum