<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;">Hi everyone.</span></font><div><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 12px;"></span></font><font class="Apple-style-span" face="Arial"><br></font><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;">I hope I am in the right place for this question.</span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial">I am trying to get a osm file ready to be rendered by Mapnik.</font></div><div><font class="Apple-style-span" face="Arial"><br></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;">But I am getting the following error with this line..</span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><br></span></font></div><div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;">postgres$ ./osm2pgsql -append -S default.style -s -d gis -C 4096 data.osm</span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><br></span></font></div><div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><i>Using projection SRS 900913 (Spherical Mercator)</i></span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><i>Setting up table: pend_point</i></span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><i>Problem reading geometry information for table pend_point - does it exist?</i></span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><i>Error occurred, cleaning up</i></span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;">I think I have set up </span></font><span class="Apple-style-span" style="line-height: 19px; "><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;">PostGIS postresql correctly. I used these great guidelines</span></font></span></div><div><span class="Apple-style-span" style="line-height: 19px;"><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><a href="http://weait.com/content/build-your-own-openstreetmap-server">http://weait.com/content/build-your-own-openstreetmap-server</a></span></font></span></div><div><span class="Apple-style-span" style="line-height: 19px;"><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><a href="http://wiki.openstreetmap.org/wiki/Mapnik">http://wiki.openstreetmap.org/wiki/Mapnik</a></span></font></span></div><div><span class="Apple-style-span" style="line-height: 19px;"><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;"><br></span></font></span></div><div><span class="Apple-style-span" style="line-height: 19px;"><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;">After solving many well documented problems I have hit this one, which comes up blank</span></font></span></div><div><span class="Apple-style-span" style="line-height: 19px;"><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 12px;">I have no idea how to move forward and would appreciate any help.</span></font></span></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;">Thanks for your time.</span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;">Simon</span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;">// this might be helpful too. when run without -append</span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px;"><div>simons-macbook-pro-15:osm2pgsql postgres$ ./osm2pgsql -S default.style -s -d gis -C 4096 data.osm</div><div>osm2pgsql SVN version 0.69-exported</div><div><br></div><div>Using projection SRS 900913 (Spherical Mercator)</div><div>Setting up table: planet_osm_point</div><div>NOTICE: table "planet_osm_point" does not exist, skipping</div><div>NOTICE: table "planet_osm_point_tmp" does not exist, skipping</div><div>Setting up table: planet_osm_line</div><div>NOTICE: table "planet_osm_line" does not exist, skipping</div><div>NOTICE: table "planet_osm_line_tmp" does not exist, skipping</div><div>Setting up table: planet_osm_polygon</div><div>NOTICE: table "planet_osm_polygon" does not exist, skipping</div><div>NOTICE: table "planet_osm_polygon_tmp" does not exist, skipping</div><div>Setting up table: planet_osm_roads</div><div>NOTICE: table "planet_osm_roads" does not exist, skipping</div><div>NOTICE: table "planet_osm_roads_tmp" does not exist, skipping</div><div>Mid: pgsql, scale=100, cache=4096MB, maxblocks=524289*8192</div><div>Setting up table: planet_osm_nodes</div><div>*** WARNING: intarray contrib module not installed</div><div>*** The resulting database will not be usable for applying diffs.</div><div>NOTICE: table "planet_osm_nodes" does not exist, skipping</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_nodes_pkey" for table "planet_osm_nodes"</div><div>Setting up table: planet_osm_ways</div><div>NOTICE: table "planet_osm_ways" does not exist, skipping</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_ways_pkey" for table "planet_osm_ways"</div><div>Setting up table: planet_osm_rels</div><div>NOTICE: table "planet_osm_rels" does not exist, skipping</div><div>NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "planet_osm_rels_pkey" for table "planet_osm_rels"</div><div><br></div><div>Reading in file: data.osm</div><div>way_changed_mark failed: ERROR: prepared statement "way_changed_mark" does not exist</div><div>(7)</div><div>Arguments were: 31892054, </div><div>Error occurred, cleaning up</div><div><br></div></span></font></div><div><font class="Apple-style-span" face="Arial"><span class="Apple-style-span" style="line-height: 19px; "><br></span></font></div></div></div></div></body></html>