[Tile-serving] [osm2pgsql-dev/osm2pgsql] Question: could not extend file "base/361191441/368615606.137": No space left on device (Discussion #2093)

[Klaus Tockloth]

Even with the option '--disable-parallel-indexing' the import of the planet file was not successful. 705 GB of free disk space is not enough for this.

```
$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/md2        2.0T  1.2T  705G  63% /               <- database
/dev/md3        5.3T  797G  4.3T  16% /home           <- osm2pgsql
...
```

```
nohup ./osm2pgsql-1.9.2 --username postgres --disable-parallel-indexing --multi-geometry --hstore --flat-nodes nodes.bin --create --number-processes 10 --database osmplanet --style openstreetmap-carto.style --tag-transform-script openstreetmap-carto.lua --input-reader=pbf planet-latest.osm.pbf >load_osmplanet.out 2>&1 &
```

```
...
2023-10-19 23:54:30  Creating geometry index on table 'planet_osm_roads'...
2023-10-19 23:57:16  Analyzing table 'planet_osm_roads'...
2023-10-19 23:57:19  All postprocessing on table 'planet_osm_roads' done in 702s (11m 42s).
2023-10-19 23:57:19  ERROR: Database error: ERROR:  could not extend file "base/384221473/394747050.145": No space left on device
...
```

Next step:

* Moving the database cluster to the larger partition (as suggested).
* This guide for this seems helpful with: [How To Move a PostgreSQL Data Directory to a New Location on Ubuntu 20.04](https://www.digitalocean.com/community/tutorials/how-to-move-a-postgresql-data-directory-to-a-new-location-on-ubuntu-20-04)



-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2093#discussioncomment-7335457
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2093/comments/7335457 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20231019/4747882a/attachment.htm>