[Geocoding] empty search_name tables

[Carlos Alberto Castaño Moraga]

Sarah,

Here is the number of rows we have. All the tables that do not appear have
0 rows

         relname          | n_live_tup
--------------------------+------------
 planet_osm_nodes         |    1422241
 planet_osm_ways          |     170652
 place                             |     125748
 placex                           |     111900
 word                             |      48307
 us_postcode                  |      32388
 country_osm_grid          |      25477
 us_statecounty               |       6138
 spatial_ref_sys               |       3911
 us_state                         |       2895
 planet_osm_rels             |        739
 country_name                |        250
 country_naturalearthdata |        229
 query_log                      |          7
 new_query_log              |          7
 import_status                 |          2

Best Regards!




2015-03-13 11:32 GMT+01:00 Sarah Hoffmann <lonvia at denofr.de>:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20150313/e74a0d29/attachment.html>