[Geocoding] osm2pgsql / Gazetteer import errors

[Brian Quinion]

On Mon, Jan 4, 2010 at 12:02 PM, Frans Hals <fhals7 at googlemail.com> wrote:
> after 4 or 5 days of importing planet.osm I have found out, that the

Are you still running osm2pgsql? or have you started the indexing process?

If you are still just running osm2pgsql after 5 days then I'd suggest
your hardware probably isn't up to a full planet import since the
initial import is about 1/8th of the import process.  That would make
the indexing on your system about another 35 days.  Feel free to try,
but just warning you.

> FATAL:  role "gis" does not exist
> FATAL:  database "gazetteerworld" does not exist

gis is the default database used by osm2pgsql.  It's possible that it
tries to connect as this somewhere in the code but if it is still
running my guess is that it isn't important.

gazetteerworld is referenced in settings.php only (by mistake, I use
both on the main server) try changing this back to 'gazetteer', but my
guess is that again it isn't anything important - osm2pgsql doesn't
reference this file at all.

> 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?

Probably it is still creating indexes.

Try doing a 'select * from pg_stat_activity;' using pgsql to see where
it is up to.

--
 Brian