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

how to reduce disk usage on write-pgsql with osmosis?

0

I am using osmosis version 0.44.1 (after simple apt install at UBUNTU 16 LTS) and fresh PostGIS, there are only few relations (and few Gb on PostGIS geometry) but this command use all my ~60Gb of free disk:

osmosis --read-pbf file=brazil-latest.osm.pbf --tag-filter \
   accept-relations admin_level=4,boundary=administrative  \
   --write-pgsql host=localhost database=pgsnapshot \
   user=postgres password="myPass"  &

How to reduce the disk consume?


Example of relation that need: here.


Dump of error messages:

org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
...
SEVERE: Thread for task 1-read-pbf failed
org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [CREATE INDEX idx_way_nodes_node_id ON way_nodes USING btree (node_id)]; ERROR: could not extend file "base/340840/351416.1": wrote only 4096 of 8192 bytes at block 167425

  Hint: Check free disk space.; nested exception is org.postgresql.util.PSQLException: ERROR: could not extend file "base/340840/351416.1": wrote only 4096 of 8192 bytes at block 167425
  Hint: Check free disk space.

asked 03 Oct '18, 14:41

ppKrauss's gravatar image

ppKrauss
95192225
accept rate: 0%

edited 03 Oct '18, 16:04

Source code available on GitHub .