Problem importing Europe

Question

Hi guys,

i seem to be having a bit of an issue importing Europe PBF

terminate called after throwing an instance of 'std::runtime_error'
  what():  CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF) ;
 failed: ERROR:  could not extend file "base/16385/4138500.7": No space left on device
HINT:  Check free disk space.

Aborted
osm@osm-tiles:~$ df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/root       440G  313G  105G  75% /
devtmpfs         16G     0   16G   0% /dev
tmpfs            16G  4.0K   16G   1% /dev/shm
tmpfs            16G  1.6G   15G  10% /run
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs            16G     0   16G   0% /sys/fs/cgroup

As you can see, i have 25% of my disk space available, or has it removed stuff once its realised its not enough space?

Accepted Answer

3

Yes, Postgres will remove the intermediate files. CREATE INDEX is an atomic operation, so there is no point in keeping files of the failed operation around. watch df -h / while the import is ongoing will show you how far it goes. There may also be quotas or mount options that prevent non-root users from filling up the disk completely, but the threshold is certainly higher than 25%.

permanent link

answered 01 May '18, 10:22

Vincent de P... ♦
17.3k●18●152●249
accept rate: 19%

Problem importing Europe

Follow this question

Related questions