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

Hi guys.. I try to resume the process but after some log like:

Starting rank 28
 Done 0 in 0 @ 0.000000 per second - FINISHED

Starting rank 29
 Done 0 in 0 @ 0.000000 per second - FINISHED

Starting rank 30
 Done 0 in 0 @ 0.000000 per second - FINISHED

I got this error:

ERRORE:  la relazione "idx_word_word_id" esiste già
ERROR: pgsql returned with error code (3)

What can I do?? maybe change product? Thanks a lot


I dropped that index and now I have similar error:

ERRORE:  la relazione "idx_search_name_nameaddress_vector" esiste già
ERROR: pgsql returned with error code (3)

It is the second index I found on sql folder (under nominatim path) inside file indices.src.sql. What I have to do?? I have to remove all index on that list??

Please I'am so close

Thanks anyway Giacomo

asked 23 Nov '15, 16:02

giacomo-keybiz's gravatar image

giacomo-keybiz
33101013
accept rate: 0%

edited 23 Nov '15, 18:14


Obviously half the indexes have already been created before your previous importing attempt failed. To finish creating the other indices run:

./utils/setup.php --create-search-indices --ignore-errors

and ignore the errors printed by postgres.

permanent link

answered 24 Nov '15, 16:38

lonvia's gravatar image

lonvia
6.2k25789
accept rate: 40%

Thanks a lot man.. Unfortunately I have read your post too late and I drop all index (already created) I found on indices.src.sql. I hope I'm not wrong..

Thanks again Giacomo

(24 Nov '15, 18:08) giacomo-keybiz
Your answer
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

question asked: 23 Nov '15, 16:02

question was seen: 2,370 times

last updated: 25 Nov '15, 09:56

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