Hi, On Wed, Dec 21, 2011 at 06:17:54AM +0700, Anwar Azulfa wrote: > Now i have user gazetteer from > http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/gazetteer > > this is my step by step installation which i follow: > > 1.createdb > > 2.import sql file > > cat /usr/share/postgresql/8.4/contrib/pg_trgm.sql | psql gazetteer > cat /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql | psql > gazetteer > cat /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql | > psql gazetteer > > 3.load planet data > ./osm2pgsql -S default.style --slim -d gazetteer -C 2048 > ~/AllMap/indonesia.osm.bz2 > > 4.copy lib into /usr/local/share > sudo mkdir /usr/local/share/gazetteer > sudo cp .libs/gazetteer.so /usr/local/share/gazetteer/gazetteer.so > > 5.add suplementary data > > when i import file below to db > cat import_country_name.sql | psql gazetteer > > i get error message like http://pastebin.com/ctQScVhA
There is currently a bug in osm2pgsql. It forgets to actually commit your data. I'm trying to get that fixed in svn. For the moment, I have a patch attached. Apply it, recompile osm2pgsql and redo everything from step 3. Sarah
Index: output-gazetteer.c =================================================================== --- output-gazetteer.c (revision 27287) +++ output-gazetteer.c (working copy) @@ -1020,6 +1020,7 @@ // Options->mid->iterate_relations( gazetteer_process_relation ); /* No longer need to access middle layer */ + Options->mid->commit(); Options->mid->stop(); /* Stop any active copy */
_______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev