This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

postgres : no space is left on disk

0

Hello, I am trying to install OSM on a virtual machine of Esxi server 6.7 whcih on debian system.

The allocated resources to the debian system are:

  • ram: 30G
  • disk space: 70G
  • CPU: 1

I am trying to import the osm map data for Germany to postgres database.

I did this command :

postgres@osm:~$ osm2pgsql --slim -d gis --hstore --multi-geometry --number-proce                                                                             sses 1 --tag-transform-script /home/osm/openstreetmap-carto/openstreetmap-carto.                                                                             lua --style /home/osm/openstreetmap-carto/openstreetmap-carto.style -C 16500 /ho                                                                             me/osm/germany-latest.osm.pbf

Then I received this error

Reading in file: /home/osm/germany-latest.osm.pbf
Using PBF parser.
Processing: Node(328827k 390.5k/s) Way(53629k 27.96k/s) Relation(0 0.00/s)COPY_END for COPY planet_osm_ways FROM STDIN;
 failed: ERROR:  could not extend file "base/16385/34513.4": No space left on device
HINT:  Check free disk space.
CONTEXT:  COPY planet_osm_ways, line 20803763

could you please help me, I am new on this part. I don not know exactly how much space is required

the output df -h on my host:

alt text

thanks for your answer. BR. Eman

asked 10 Nov '20, 09:30

Eman7's gravatar image

Eman7
11112
accept rate: 0%

edited 10 Nov '20, 13:05

scai's gravatar image

scai ♦
33.3k21309459


One Answer:

1

A Germany import in the form you are attempting, with a data file from November 2020, will create a database of about 77 GB but will temporarily use about 90 GB of disk space.

It appears that your system only has 10 GB of free disk space on the / volume. You write that you have 70 GB but that space is nowhere to be seen in your "df" output, and would also not be sufficient.

answered 11 Nov '20, 16:40

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

Source code available on GitHub .