[OSM-dev] osm2pgsql Help ?

Ian Dees ian.dees at gmail.com
Tue Oct 12 16:28:14 BST 2010

On Tue, Oct 12, 2010 at 9:32 AM, 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 ?
> Thanks,
> Ronan
I might be wrong, but I think the osm2pgsql actions occur within a
transaction. Since your transaction failed it most likely has been rolled
back, thus leaving you with an essentially empty database. People more
familiar with osm2pgsql should tell me if I'm wrong, though.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20101012/7d5f0ac5/attachment-0001.html>

More information about the dev mailing list