Re: [OSM-talk] Planet, osm2pgsql interruptus, and reclaiming disk space
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 ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Planet, osm2pgsql interruptus, and reclaiming disk space
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. -mike. michal migurski- m...@stamen.com 415.558.1610 ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Planet, osm2pgsql interruptus, and reclaiming disk space
On Sun, Feb 21, 2010 at 22:45, Michal Migurski m...@stamen.com wrote: 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. What about something like this: http://phppgadmin.sourceforge.net/ -- -S ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk