[OSM-newbies] problem with osm2pgsql

[simon blackmore]

Hi everyone.

I hope I am in the right place for this question.

I am trying to get a osm file ready to be rendered by Mapnik.

But I am getting the following error with this line..

postgres$ ./osm2pgsql -append -S default.style -s -d gis -C 4096  
data.osm

Using projection SRS 900913 (Spherical Mercator)
Setting up table: pend_point
Problem reading geometry information for table pend_point - does it  
exist?
Error occurred, cleaning up

I think I have set up  PostGIS postresql correctly. I used these great  
guidelines
http://weait.com/content/build-your-own-openstreetmap-server
http://wiki.openstreetmap.org/wiki/Mapnik

After solving many well documented problems I have hit this one, which  
comes up blank
I have no idea how to move forward and would appreciate any help.

Thanks for your time.

Simon



// this might be helpful too. when run without -append

simons-macbook-pro-15:osm2pgsql postgres$ ./osm2pgsql -S default.style  
-s -d gis -C 4096 data.osm
osm2pgsql SVN version 0.69-exported

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE:  table "planet_osm_point" does not exist, skipping
NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE:  table "planet_osm_line" does not exist, skipping
NOTICE:  table "planet_osm_line_tmp" does not exist, skipping
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
Setting up table: planet_osm_roads
NOTICE:  table "planet_osm_roads" does not exist, skipping
NOTICE:  table "planet_osm_roads_tmp" does not exist, skipping
Mid: pgsql, scale=100, cache=4096MB, maxblocks=524289*8192
Setting up table: planet_osm_nodes
*** WARNING: intarray contrib module not installed
*** The resulting database will not be usable for applying diffs.
NOTICE:  table "planet_osm_nodes" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"planet_osm_nodes_pkey" for table "planet_osm_nodes"
Setting up table: planet_osm_ways
NOTICE:  table "planet_osm_ways" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"planet_osm_ways_pkey" for table "planet_osm_ways"
Setting up table: planet_osm_rels
NOTICE:  table "planet_osm_rels" does not exist, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index  
"planet_osm_rels_pkey" for table "planet_osm_rels"

Reading in file: data.osm
way_changed_mark failed: ERROR:  prepared statement "way_changed_mark"  
does not exist
(7)
Arguments were: 31892054,
Error occurred, cleaning up


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/newbies/attachments/20100820/83066e44/attachment.html>