[Geocoding] osm2pgsql / Gazetteer import errors
Frans Hals
fhals7 at googlemail.com
Mon Jan 4 12:02:09 GMT 2010
Hi,
after 4 or 5 days of importing planet.osm I have found out, that the
Readme.txt providing the necessary steps for building your own
geocoding service may be incomplete
(http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/gazetteer/README.txt)
Watching the logfiles of postgres I have found the following errors:
FATAL: role "gis" does not exist
FATAL: database "gazetteerworld" does not exist
Both are repeated several times between other log lines.
The Readme doesn't creates a user "gis" for gazetteer, nor does it
mention the creation of the database gazetteerworld.
Am I missing some important part and have to restart the import?
Actually the postmaster is still working, while osm2pgsql is in idle.
Will there be a message when it is ready or am I finished when I see
the text below?
Reading in file: /store/planet.osm.bz2
Processing: Node(519844k) Way(38084k) Relation(316k)
Node stats: total(519844093), max(598382806)
Way stats: total(38084898), max(46870218)
Relation stats: total(316157), max(369220)
node cache: stored: 104821214(20.16%), storage efficiency: 99.96%, hit
rate: 19.04%
Stopping table: planet_osm_nodes
Stopping table: planet_osm_ways
Stopping table: planet_osm_rels
Building index on table: planet_osm_ways
Stopped table: planet_osm_nodes
Building index on table: planet_osm_rels
Stopped table: planet_osm_rels
Thanks for some enlightenment
Frans
More information about the Geocoding
mailing list