[OSM-dev] osm2pgsql Help ?

Ronan Crowley ronan.crowley at gmail.com
Tue Oct 12 15:52:57 BST 2010

Yeah .... I have no free space left.

I'm doing this on an Amazon Virtual machine.

So my tablespace (and all my data I thought) was being written to /mnt/sdo
where there is over 200GB of space.

What I'm looking for is a way to continue / re-try the index building from
where it fail, so I don't loose 4 days !

I would just re-run the osm2pgsql program with the -i paramater, but I don't
want to wait 4 more days.


On 12 October 2010 15:46, Emilie Laffray <emilie.laffray at gmail.com> wrote:

> On 12 October 2010 15:32, Ronan Crowley <ronan.crowley at gmail.com> wrote:
>> Hi,
>> I have just run the osm2pgsql script.
>> It has taken over 4 days for me.
>> However, the user I imported into had a tablespace that was on  /mnt/sdo
>> When the program got to building the indexes, I got the following error :
>> CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes
>> gin__int_ops) TABLESPACE pg_default;
>>  failed: ERROR:  could not extend relation base/16391/832804: No space
>> left on device
>> HINT:  Check free disk space.
>> Now looking at the code I can see that had I used a -i parameter I could
>> have avoided this.
>> What I want to know is, is there any way I can manually continue the
>> outstanding steps  ?
>> (Perhaps redoing the )
>> OR
>> Is there a whay to re-run the program, just to create the indexes ?
> I think you will need to free space. It is saying that your hard drive is
> full.
> Emilie Laffray
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20101012/0738b314/attachment.html>

More information about the dev mailing list