Hi, i'm doing a setup.php -all for a full planet.pbf, after all steps without errors(aparently) when i exec --index option appears this errors: what's the meaning of these errors? Starting rank 25 Done 19 in 0 @ 19.000000 per second - ETA (seconds): 2187.684326 Done 210 in 1 @ 210.000000 per second - ETA (seconds): 197.023804 Done 258 in 1 @ 258.000000 per second - ETA (seconds): 160.182175 index_placex: UPDATE failed: ERROR: relation "planet_osm_rels" does not exist LINE 1: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_i... ^ QUERY: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_id::integer] and members @> ARRAY['n'||NEW.osm_id] CONTEXT: PL/pgSQL function "placex_update" line 112 at FOR over SELECT rows index_placex: UPDATE failed: ERROR: relation "planet_osm_rels" does not exist LINE 1: select * from planet_osm_rels where parts @> ARRAY[NEW.osm_i... .... ... .... same error asked 03 Mar '12, 02:27  luup2k edited 03 Mar '12, 09:00  Frederik Ramm ♦ |
2 Answers:
These kind of installation problems should better be discussed on one of the developer mailing lists. For Nominatim, you can use either the geocoding mailing list or the more general dev list. answered 09 Mar '12, 22:39  lonvia I politely disagree. If you can figure out, it should be here so when other people have the same error, they can google it. (01 May '12, 23:25) rafamvc |
I had the same problem. It turns out I was using osm2pgsql provided by my distro and not the one from SVN. Is this your case as well? answered 02 May '12, 18:58  Norm1 |
i'm using setup.php script
passthru($osm2pgsql.' -lsc -O gazetteer -C 9000 --hstore -d '.$aDSNInfo['database'].' '.$aCMDResult['osm-file']);
additional: i'm testing with other small country ( belgium.osm.pbf ) and with this country i have other fail... but too in index proceseing and related with planet_osm_ tables
QUERY: select nodes from planet_osm_ways where id = wayid
CONTEXT: PL/pgSQL function "create_interpolation" line 26 at SQL statement
PL/pgSQL function "placex_update" line 57 at assignment
Done 4 in 50 @ 0.080000 per second - Rank 28 ETA (seconds): 28425.000000
index_placex: UPDATE failed: ERROR: relation "planet_osm_ways" does not exist
LINE 1: select nodes from planet_osm_ways where id = wayid