[OSM-talk] Planet, osm2pgsql interruptus, and reclaiming disk space

Jon Burgess jburgess777 at googlemail.com
Sun Feb 21 18:37:00 GMT 2010

On Sun, 2010-02-21 at 10:12 -0800, Michal Migurski wrote:
> Hi,
> I have a problem with osm2pgsql and postgres, I hope someone can point  
> me in the right direction for a fix. I started up a whole-planet  
> osm2pgsql import session from a recent planet dump. While that was  
> going on, the computer had to be rebooted and the process was  
> interrupted. Now I have no data tables (okay) and a few dozen GB less  
> disk space (not okay). I tried to "vacuum full" the planet_osm  
> database, but didn't reclaim any space. Where does storage go when  
> osm2pgsql is rudely interrupted like that? Temp files? A core dump  
> somewhere? Any advice much appreciated.

osm2pgsql only stores data in PostgreSQL. I imagine that the extra disk
space is in use in the postgres DB directory. I should get cleared and
re-used if you begin the import again. Otherwise you should be able to
reclaim it immediately by dropping the database.


More information about the talk mailing list