[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.
Jon
More information about the talk
mailing list