Hi Gregory, The 'NOTICE' output you pasted below is standard output, nothing to worry about. Generally if the tables are missing it means that the import failed (e.g. if you ran out of memory). So you need to watch the very end of the osm2pgsql output for clues.
I would recommend trying to import a small extract first to confirm that everything is working. On older ubuntu versions with packaged geos sometimes tables can be empty. This does not appear to be your problem, but it would be good to rule this out with a small extract first, before importing planet. Lastly, osm2pgsql questions are likely better ask in the future at http://lists.openstreetmap.org/listinfo/dev since this list is targeted at Mapnik rendering issues. Dane On Oct 4, 2011, at 10:56 AM, Gregory Mace wrote: > I've successfully imported the planet-latest file into postgres8.4 on ubuntu > 10.04 and run into this error when trying to generate an image. When I look > in the db, that table is not there. What I don't understand is that during > the import it says: > > osm2pgsql import output: > > Setting up table: planet_osm_polygon > NOTICE: table > "planet_osm_polygon" > does not exist, skipping > NOTICE: table > "planet_osm_polygon_tmp" does not exist, skipping > > but all the documentation for importing planet-latest indicates that this is > normal. > > > mapnik ./generate_image.py output > > ///, line 42, in <module> > mapnik.load_map(m,mapfile) > RuntimeError: PSQL error: > ERROR: relation "planet_osm_polygon" does not exist > LINE 4: from planet_osm_polygon > ^ > Full sql was: 'select * from > (select > way,aeroway,amenity,landuse,leisure,man_made,military,"natural",power,tourism,name,highway, > case when religion in ('christian','jewish') then religion else > 'INT-generic'::text end as religion > from planet_osm_polygon > where landuse is not null > or leisure is not null > or aeroway in ('apron','aerodrome') > or amenity in > ('parking','university','college','school','hospital','kindergarten','grave_yard') > or military in ('barracks','danger_area') > or "natural" in > ('field','beach','desert','heath','mud','wood','sand','scrub') > or power in ('station','sub_station','generator') > or tourism in > ('attraction','camp_site','caravan_site','picnic_site','zoo') > or highway in ('services','rest_area') > order by z_order,way_area desc > ) as leisure > limit 0' > (encountered during parsing of layer 'land cover') > > is there some script that I have forgotten to run on the db ( before > importing )? > > Thx > > > > _______________________________________________ > Mapnik-users mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/mapnik-users _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
