[OSM-talk] Error: Osm2pgsql Error Importing latest Planet!! OUT of MEMORY
Dear experts, I tried importing whole Planet into Postgis Database using osm2pgsql.exe. After 7 days, I have got the Out of Memory error in slim mode. RAM: 16 GB (Windows 7 64) Harddisk 1 TB. The command was: osm2pgsql.exe -d Planet --latlong --slim -c -C 1500 -H localhost -P 5432 -U osm -W -S default.style .\Planet-Latest.osm.bz2 I've got error after 'Going over pending ways' as you see in the report below. Please help and give me advice for solution. thank you in advance, regards, Saph Report of osm2pgsql.exe: osm2pgsql.exe -d Planet --latlong --slim -c -C 1500 -H localhost -P 543 2 -U osm -W -S default.style .\Planet-Latest.osm.bz2 osm2pgsql SVN version 0.69-21289M Password: Using projection SRS 4326 (Latlong) 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=1000, cache=1500MB, maxblocks=192001*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_n odes 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_wa ys 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_re ls !! You are running this on 32bit system, so at most !! 3GB of RAM can be used. If you encounter unexpected !! exceptions during import, you should try running in slim !! mode using parameter -s. Reading in file: .\OsmFiles\Planet-Latest.osm.bz2 Unknown node type 8 Processing: Node(1118130k) Way(97901k) Relation(819k) Exception caught processing way id=1388172 Processing: Node(1118130k) Way(97901k) Relation(862k) Exception caught processing way id=1440075 Processing: Node(1118130k) Way(97901k) Relation(898k) Exception caught processing way id=1479960 Processing: Node(1118130k) Way(97901k) Relation(1019k) Node stats: total(1118130701), max(1325889367) Way stats: total(97901806), max(117747569) Relation stats: total(1019004), max(1625305) Going over pending ways processing way (25977k)way_done failed: ERROR: out of memory DETAIL: Failed on request of size 419430400. (7) Arguments were: 75141421, Error occurred, cleaning up C:\Cartography\MapnikShop\OsmToPgsqlECHO Finished at: 12.07.2011 22:48:40,73 Finished at: 12.07.2011 22:48:40,73 C:\Cartography\MapnikShop\OsmToPgsqlPause___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Unkown Node Type 8 by Planet import
Good Morning. to day I tried to import Planet_Latest.osm.bz2 into database named Planet of Potgis_template. I used osm2pgsql, as usual, to import this planet file, but there is error very fast after start the process as follows: reading in File: Planet_Latest.osm.bz2 Error: ' Unknown Node Type 8' Please help about the reason and solution. Thanks in advance, Saphy ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] SOS. no green area in map using StyleSheet mapnik
Hallo, I used Mapnik and osm.xml as default StyleSheet. There are not any green ara on the map. Please let me know, where can I get a better StyleSheet like map of OpenStreetMap.org ? Please see the Attachment. Thanks, Saphy attachment: Meta_12_2136_1397.png___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] OSM Uniteed State part 00 and part 01
* americas.osm.bz2.part.00 (3814.7M) * americas.osm.bz2.part.01 (2590.9M)Dears, on the website ' http://downloads.cloudmade.com/americas#downloads_breadcrumbs ' there are two files for USA. as part 00 and 01. But I don't know how should I combine them. Please let me know, what these are and how I would be able to combine them to a bz2 file as usual? thanks, Saphy ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Coastline anf blau background
Dear experts, I rendered some area by mapnik from France and Germany derived from Europe.osm.bz2. But some part of them are blue. is it some problem with small coast line in this case? or no, that is because of some thing else? please see the attachment. Thank you in advance, Saphy attachment: Meta_10_535_352.png___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Wrong Background in Germany MAP
Dears, i rendered a tile from Gemany using mapnik from a small area as BBX= 7.8828125, 48.6909603909254, 8.1375, 48.8823727870095 But the result is blue as you see in attachment. What is the reason of that, and what should we do? regards, Saphyattachment: Meta_10_534_352.png___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Import OSM2PGSQL error to databse Europe
Dears, I tried again to Import europe.osm.bz2 into Database postgis, but I have got again our of memory error. Please see the attachment as reference. Pendig_ways faild : out of memory attachment: errorOSM.GIF___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Blue color in part of MAP by MAPNIK
Please see attachment png Dear friend, I produced a MAP by Mapnik in Boarder of France and Germany directly from Database FRANCE of france.osm.bz2. But part of maps are colored blue, as you see in attachment. Only new boarder but inside the country it is blue. Please let me know about the reason. regards, Saphy Meta_10_532_351.png Description: Binary data ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Osmosis and Mapnik
Dear friend, why osmosis is able to work with PostgreSQL database? Is it designed for import in purpose of rendering by Mapnik? can osmosis be any other equivalent tool for oms2pgsql? regards, saphy___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] osm2pgsql for 64-bit
For windows 64 there is need of osm2pgsql for 64-bit.is there any version of that available for users? regards, Saphy___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk