I am trying to append some OSM data for the state of Maryland from CloudMade onto an existing database using the Windows version of osm2pgsql. When I don’t use slim mode, an error occurs:
osm2pgsql --style default.style -H -U -d -p osm -a -l maryland.osm.bz2
osm2pgsql SVN version 0.69-21289M
Using projection SRS 4326 (Latlong)
Setting up table: osm_point
NOTICE: table “osm_point_tmp” does not exist, skipping
Setting up table: osm_line
NOTICE: table “osm_line_tmp” does not exist, skipping
Setting up table: osm_polygon
NOTICE: table “osm_polygon_tmp” does not exist, skipping
Setting up table: osm_roads
NOTICE: table “osm_roads_tmp” does not exist, skipping
Mid: Ram, scale=10000000
!! 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: USA\maryland.osm.bz2
Processing: Node(7425k) Way(376k) Relation(0k)Error allocating ways
Error occurred, cleaning up
I assumed the problem had to do with not using slim mode, so I then tried that. No luck, another error occurs:
osm2pgsql --style default.style -H -U -d -p osm -a -l -s maryland.osm.bz2
osm2pgsql SVN version 0.69-21289M
Using projection SRS 4326 (Latlong)
Setting up table: osm_point
NOTICE: table “osm_point_tmp” does not exist, skipping
Setting up table: osm_line
NOTICE: table “osm_line_tmp” does not exist, skipping
Setting up table: osm_polygon
NOTICE: table “osm_polygon_tmp” does not exist, skipping
Setting up table: osm_roads
NOTICE: table “osm_roads_tmp” does not exist, skipping
Mid: pgsql, scale=10000000, cache=800MB, maxblocks=102401*8192
Setting up table: osm_nodes
*** WARNING: intarray contrib module not installed
*** The resulting database will not be usable for applying diffs.
Setting up table: osm_ways
Setting up table: osm_rels
!! 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: USA\maryland.osm.bz2
Processing: Node(7420k) Way(0k) Relation(0k)COPY_END for COPY osm_nodes FROM STDIN;
failed: ERROR: could not extend file “base/2851890/2863247”: No space left on device
HINT: Check free disk space.
CONTEXT: COPY osm_nodes, line 41: “278485 390681392 -768323541 \N”
Error occurred, cleaning up
There is plenty of disk space on my computer (over 50 GB on each drive), so this cannot be the real problem. I have successfully appended smaller files to my database without using slim mode. In the past, I have gone around these issues by using smaller administrative units from CloudMade. There is no smaller unit than a state, so I am stuck with this file.
Help?