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

Michal Migurski mike at stamen.com
Sun Feb 21 21:45:59 GMT 2010

On Feb 21, 2010, at 10:37 AM, Jon Burgess wrote:

> 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.

Thanks Jon.

I'm hesitant to drop the DB because of some other data stored there,  
but it's good to know that osm2pgsql doesn't have any other storage  
squireled away elsewhere.


michal migurski- mike at stamen.com

More information about the talk mailing list