29.10.2012, 16:13, "Sarah Hoffmann" <[email protected]>:
> This all looks all good on a quick glance. A more basic question: are
> you sure that your import actually finishes? You should have seen
> lots of lines like this:
>
> Done 216 in 10 @ 21.600000 per second - Rank 26 ETA (seconds): 72.916664
>
> And the final output should be a whole bunch of CREATE INDEX.
I can see bunch of CREATE INDEX both in setup.php log and htop, but the final
lines are different. Here's the last part of my import log:
--------- 8< -----------
...
...
addgeometrycolumn
-----------------------------------------------------------------
public.location_road_0.geometry SRID:4326 TYPE:GEOMETRY DIMS:2
(1 row)
CREATE INDEX
CREATE INDEX
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
WARNING: wikipedia article dump file not found - places will have default
importance
WARNING: wikipedia redirect dump file not found - some place importance
values may be missing
Drop old Data
.....................................................................................................................................................................................................................................................................
Loading word list
SET
SET
SET
SET
SET
SET
SET
SET
CREATE TABLE
count
-------
32621
(1 row)
count
-------
703
(1 row)
count
-------
11445
(1 row)
UPDATE 5092
DROP TABLE
Load Data
.................................
Reanalysing database...
NOTICE: no notnull values, invalid stats
NOTICE: no notnull values, invalid stats
ANALYZE
settings/configuration.txt already exists
Getting state file:
http://planet.openstreetmap.org/replication/minute/000/065/479.state.txt
Updating DB status
-------- >8 ------------
And that's it.
_______________________________________________
Geocoding mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/geocoding
