[Geocoding] empty search_name tables

Sarah Hoffmann lonvia at denofr.de
Fri Mar 13 10:32:55 UTC 2015


Hi Carlos,

On Fri, Mar 13, 2015 at 09:23:27AM +0100, Carlos Alberto CastaƱo Moraga wrote:
> I use postgres 9.4, postgis 9.1, Nominatim 2.3.1 from git on a Solaris x86
> server that runs an apache2 with php5. I have donwloaded the luxembourg pbf
> file from geofabrik website, without any preprocessing. For the
> installation, I use the following command:
> 
> ./utils/setup.php --osm-file louxembourg.osm.pbf --all
> 
> and it finishes ok.
> 
> I have been reading some posts through google and I think that something is
> not working when the indices are created. I get the following output:
> 
> (...)
> 
> Starting rank 27
>   Done 0 in 0 @ 0.000000 per second - FINISHED
> 
> 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 have checked the postgres logs and so on, but I don't see any error or
> any clue. The only hint I have is that search_names tables and
> location_area, location_road and so on are empty, but I don't know why.
> 
> Could you please help us to discover what I am missing?

The final tables in your database have no data. From the output it is not
yet clear where the data gets lost. Could you check the row count for the
following tables: planet_osm_ways, place, placex

Sarah



More information about the Geocoding mailing list