<div class="gmail_quote">On Tue, Oct 12, 2010 at 9:32 AM, Ronan Crowley <span dir="ltr"><<a href="mailto:ronan.crowley@gmail.com">ronan.crowley@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi,<br><br>I have just run the osm2pgsql script.<br>It has taken over 4 days for me.<br><br>However, the user I imported into had a tablespace that was on /mnt/sdo<br><br>When the program got to building the indexes, I got the following error :<br>
<br>CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes gin__int_ops) TABLESPACE pg_default;<br> failed: ERROR: could not extend relation base/16391/832804: No space left on device<br>HINT: Check free disk space.<br>
<br>Now looking at the code I can see that had I used a -i parameter I could have avoided this.<br><br>What I want to know is, is there any way I can manually continue the outstanding steps ?<br>(Perhaps redoing the )<br>
OR<br>Is there a whay to re-run the program, just to create the indexes ?<br><br>Thanks,<br><font color="#888888"><font color="#888888">Ronan</font>
<br></font><br></blockquote><div><br></div><div>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.</div>
</div><br>