<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Yes, sorry, here is the command and error message:<br><br>http://www.prodevelop.es/files/fm/public/downloads/wxp_console.png<br> <br><br>Regards,<br>Juan Lucas<br><br><br>--- On <b>Mon, 7/19/10, Graham Jones <i><grahamjones139@googlemail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Graham Jones <grahamjones139@googlemail.com><br>Subject: Re: [OSM-talk] OSM-to-PostGIS issues<br>To: "Juan Lucas Domínguez Rubio" <juan_lucas_dr@yahoo.com><br>Date: Monday, July 19, 2010, 12:42 PM<br><br><div id="yiv851060933">Juan Lucas,<div>I think you attached the wrong link - you have not attached the error message?</div><div><br></div><div>I have not used osm2pgsql on windows, but on my linux machine I have seen errors if I have not used 'slim' mode (-s parameter).</div>
<div><br></div><div>Graham.<br><br><div class="gmail_quote">On 19 July 2010 11:33, Juan Lucas Domínguez Rubio <span dir="ltr"><<a rel="nofollow" ymailto="mailto:juan_lucas_dr@yahoo.com" target="_blank" href="/mc/compose?to=juan_lucas_dr@yahoo.com">juan_lucas_dr@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font: inherit;" valign="top">Hello, list:<br> <br>I've tried to export a 9.5 GB (150 GB uncomp.) planet to a PostGIS DB @ localhost on a Windows XP machine (1.5 GB RAM). I have tuned the DB parameters like this:<br>
<br>shared_buffers = 256MB<br>checkpoint_segments = 20<br>maintenance_work_mem = 256MB<br>autovacuum = off<br><br>postgresql.conf file here:<br><br><a rel="nofollow" target="_blank" href="http://www.prodevelop.es/files/fm/public/downloads/postgresql.conf.txt">http://www.prodevelop.es/files/fm/public/downloads/postgresql.conf.txt</a><br>
<br>but I still get the same error message I got in the previous attempt (with no DB tuning). See command parameters and error message here:<br><br><a rel="nofollow" target="_blank" href="http://www.prodevelop.es/files/fm/public/downloads/postgresql.conf.txt">http://www.prodevelop.es/files/fm/public/downloads/postgresql.conf.txt</a>.<br>
<br>Any ideas why this happens?<br>Not enough RAM?<br>osm2pgsql is not Windows-friendly?<br>DB tuning needs double-checking?<br>Anybody has done this on WXP?<br> <br>Regards,<br>Juan Lucas<br></td></tr></tbody></table><br>
<br>_______________________________________________<br>
talk mailing list<br>
<a rel="nofollow" ymailto="mailto:talk@openstreetmap.org" target="_blank" href="/mc/compose?to=talk@openstreetmap.org">talk@openstreetmap.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.openstreetmap.org/listinfo/talk">http://lists.openstreetmap.org/listinfo/talk</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Dr. Graham Jones<br>Hartlepool, UK<br>email: <a rel="nofollow" ymailto="mailto:grahamjones139@gmail.com" target="_blank" href="/mc/compose?to=grahamjones139@gmail.com">grahamjones139@gmail.com</a><br>
</div>
</div></blockquote></td></tr></table><br>