<div dir="ltr">Hi Sarah,<div><br></div><div>Thank you very much for your answer. Here is the output of the things I had to check:</div><div><br></div><div>A) run ./utils/setup.php --create-functions</div><div><br></div><div>I think there is no error. Here you can find the output.</div><div><br></div><div><div>Functions</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>NOTICE: drop cascades to function get_addressdata(bigint)</div><div>DROP TYPE</div><div>CREATE TYPE</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>NOTICE: drop cascades to function get_wikipedia_match(hstore,character varying)</div><div>DROP TYPE</div><div>CREATE TYPE</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>CREATE FUNCTION</div><div>Helper functions for postgis >= 2.0</div><div>CREATE FUNCTION</div><div>Setup finished.</div></div><div><br></div><div>B) T<span style="font-size:12.8000001907349px">riggers installed (psql nominatim and </span><span style="font-size:12.8000001907349px">the '\d placex')</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><div style="font-size:12.8000001907349px">Triggers:</div><div style="font-size:12.8000001907349px"> placex_before_delete AFTER DELETE ON placex FOR EACH ROW EXECUTE PROCEDURE placex_delete()</div><div style="font-size:12.8000001907349px"> placex_before_insert BEFORE INSERT ON placex FOR EACH ROW EXECUTE PROCEDURE placex_insert()</div><div style="font-size:12.8000001907349px"> placex_before_update BEFORE UPDATE ON placex FOR EACH ROW EXECUTE PROCEDURE placex_update()</div></div><div><br></div><div>C) <span style="font-size:12.8000001907349px">check the number of items to be indexed:</span></div><span style="font-size:12.8000001907349px"> SELECT count(*) FROM placex WHERE indexed_status > 0;</span><div><span style="font-size:12.8000001907349px"><br></span></div><div><div style="font-size:12.8000001907349px"> count </div><div style="font-size:12.8000001907349px">--------</div><div style="font-size:12.8000001907349px"> 111900</div><div style="font-size:12.8000001907349px">(1 row)</div></div><div><span style="font-size:12.8000001907349px"><br></span><div class="gmail_extra">I think everything is OK. What would be the next step??</div><div class="gmail_extra"><br></div><div class="gmail_extra">Best Regards!</div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-03-14 15:09 GMT+01:00 Sarah Hoffmann <span dir="ltr"><<a href="mailto:lonvia@denofr.de" target="_blank">lonvia@denofr.de</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span class="">On Fri, Mar 13, 2015 at 01:30:21PM +0100, Carlos Alberto Castaño Moraga wrote:<br>
> Sarah,<br>
><br>
> Here is the number of rows we have. All the tables that do not appear have<br>
> 0 rows<br>
><br>
> relname | n_live_tup<br>
> --------------------------+------------<br>
> planet_osm_nodes | 1422241<br>
> planet_osm_ways | 170652<br>
> place | 125748<br>
> placex | 111900<br>
> word | 48307<br>
<br>
</span>Those are the interesting numbers and they look about right. That means<br>
that the final indexing step is not doing what it is supposed to. Please<br>
also check the following:<br>
<br>
- run ./utils/setup/php --create-functions and make sure no error is<br>
reported, in particular no error about missing library functions<br>
- check that placex has three triggers installed (psql nominatim and<br>
the '\d placex')<br>
- check the number of items to be indexed:<br>
SELECT count(*) FROM placex WHERE indexed_status > 0;<br>
<br>
Sarah<br>
<div class=""><div class="h5"><br>
> 2015-03-13 11:32 GMT+01:00 Sarah Hoffmann <<a href="mailto:lonvia@denofr.de">lonvia@denofr.de</a>>:<br>
><br>
> > Hi Carlos,<br>
> ><br>
> > On Fri, Mar 13, 2015 at 09:23:27AM +0100, Carlos Alberto Castaño Moraga<br>
> > wrote:<br>
> > > I use postgres 9.4, postgis 9.1, Nominatim 2.3.1 from git on a Solaris<br>
> > x86<br>
> > > server that runs an apache2 with php5. I have donwloaded the luxembourg<br>
> > pbf<br>
> > > file from geofabrik website, without any preprocessing. For the<br>
> > > installation, I use the following command:<br>
> > ><br>
> > > ./utils/setup.php --osm-file louxembourg.osm.pbf --all<br>
> > ><br>
> > > and it finishes ok.<br>
> > ><br>
> > > I have been reading some posts through google and I think that something<br>
> > is<br>
> > > not working when the indices are created. I get the following output:<br>
> > ><br>
> > > (...)<br>
> > ><br>
> > > Starting rank 27<br>
> > > Done 0 in 0 @ 0.000000 per second - FINISHED<br>
> > ><br>
> > > Starting rank 28<br>
> > > Done 0 in 0 @ 0.000000 per second - FINISHED<br>
> > ><br>
> > > Starting rank 29<br>
> > > Done 0 in 0 @ 0.000000 per second - FINISHED<br>
> > ><br>
> > > Starting rank 30<br>
> > > Done 0 in 0 @ 0.000000 per second - FINISHED<br>
> > ><br>
> > > I have checked the postgres logs and so on, but I don't see any error or<br>
> > > any clue. The only hint I have is that search_names tables and<br>
> > > location_area, location_road and so on are empty, but I don't know why.<br>
> > ><br>
> > > Could you please help us to discover what I am missing?<br>
> ><br>
> > The final tables in your database have no data. From the output it is not<br>
> > yet clear where the data gets lost. Could you check the row count for the<br>
> > following tables: planet_osm_ways, place, placex<br>
> ><br>
> > Sarah<br>
> ><br>
</div></div></blockquote></div><br></div></div></div>