Thanks guys. Indeed sth wrong with PostgreSQL. Not looking at the size, I tried to open the log file. KDE/kate did not like it. It was 7+Gig! Anyhow, stopped PostgreSQL deleted the log, restarted PostgreSQL, and ran generate_image.py. Indeed masses of errors in the log. Now I know the cause... But reading the log, I do not understand anything of it.... I hope there is some one who does understand this. See a fraction of the log below.
> On Fri, Oct 30, 2009 at 10:03 AM, Wim de Vries <[email protected]> wrote: >> Hi, >> I installed Mapnik successfully. I downloaded and 'osm2pgsql -m >> netherlands.osm.bz' (from geofabrik). >> generate_image.py and generate_tiles.py gave no errors. >> I played with the zoom level. Still, I can only get shape images with >> some >> vague lines, but no further details. >> Did not find anything about this problem after googling for some hours. >> Is there sth. wrong in the (generated) osm.xml? >> Thanks. > > Look at your PostgreSQL error log. Perhaps you are using too old a > version of mapnik or some other tools in the stack. ----------------- 2009-10-30 13:36:16 CET ERROR: column "barrier" does not exist at character 144 2009-10-30 13:36:16 CET STATEMENT: select asbinary(way) as geom,"aerialway","amenity","disused","name","natural","railway","tourism" from (select * from planet_osm_polygon where barrier IS NOT NULL or amenity IS NOT NULL or tourism is NOT NULL or railway is NOT NULL or "natural" is NOT NULL or highway is NOT NULL or aeroway is NOT NULL or aerialway is NOT NULL or power_source is NOT NULL or man_made is NOT NULL) as amenity where way && setSRID('BOX3D(451957.1326206906 6753233.31802053,556597.4539663679 6857873.639366206)'::box3d,900913) 2009-10-30 13:36:17 CET ERROR: function asbinary() does not exist at character 8 2009-10-30 13:36:17 CET HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2009-10-30 13:36:17 CET STATEMENT: select asbinary() as geom,"highway","length","name","ref" from (select way,highway,aeroway,name,ref,char_length(ref) as length, case when bridge in ('yes','true','1') then 'yes'::text else bridge end as bridge from planet_osm_line where waterway IS NULL and leisure IS NULL and landuse IS NULL and (name is not null or ref is not null) ) as roads where && setSRID('BOX3D(451957.1326206906 6753233.31802053,556597.4539663679 6857873.639366206)'::box3d,723529774) 2009-10-30 13:36:17 CET ERROR: column "ele" does not exist at character 174 2009-10-30 13:36:17 CET STATEMENT: select asbinary() as geom,"ele","highway","military","name","natural","place","ref" from (select way,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,ele,name,ref,military,aeroway,'yes'::text as point from planet_osm_point where amenity is not null or leisure is not null or landuse is not null or tourism is not null or "natural" is not null or man_made='lighthouse' or place='island' or highway='motorway_junction' or military='danger_area' or aeroway='gate' ) as text where && setSRID('BOX3D(451957.1326206906 6753233.31802053,556597.4539663679 6857873.639366206)'::box3d,1936090468) 2009-10-30 13:36:17 CET ERROR: function asbinary() does not exist at character 8 2009-10-30 13:36:17 CET HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2009-10-30 13:36:17 CET STATEMENT: select asbinary() as geom,"ele","highway","military","name","natural","place","ref" from (select way,aeroway,amenity,highway,leisure,landuse,man_made,"natural",place,tourism,NULL as ele,name,ref,military,'no'::text as point from planet_osm_polygon where amenity is not null or leisure is not null or landuse is not null or tourism is not null or "natural" is not null or man_made='lighthouse' or place='island' or military='danger_area' ) as text where && setSRID('BOX3D(451957.1326206906 6753233.31802053,556597.4539663679 6857873.639366206)'::box3d,723529774) 2009-10-30 13:36:17 CET ERROR: function asbinary() does not exist at character 8 2009-10-30 13:36:17 CET HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2009-10-30 13:36:17 CET STATEMENT: select asbinary() as geom,"name","way_area" from (select way,way_area,name from planet_osm_polygon where name is not null and (waterway is null or waterway <> 'riverbank') order by z_order,way_area desc ) as text where && setSRID('BOX3D(451957.1326206906 6753233.31802053,556597.4539663679 6857873.639366206)'::box3d,723529774) > > _______________________________________________ > newbies mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/newbies > _______________________________________________ newbies mailing list [email protected] http://lists.openstreetmap.org/listinfo/newbies
