[OSM-dev] OSM-to-PostGIS issues

[Emilie Laffray]

On 19 July 2010 12:54, Juan Lucas Domínguez Rubio
<juan_lucas_dr at yahoo.com>wrote:

> Hello, list:
>
> 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:
>
> shared_buffers = 256MB
> checkpoint_segments = 20
> maintenance_work_mem = 256MB
> autovacuum = off
>
> postgresql.conf file here:
>
> http://www.prodevelop.es/files/fm/public/downloads/postgresql.conf.txt
>
> 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:
>
> http://www.prodevelop.es/files/fm/public/downloads/wxp_console.png
>
>
>
> Any ideas why this happens?
> Not enough RAM?
> osm2pgsql is not Windows-friendly?
> DB tuning needs double-checking?
> Anybody has done this on WXP?
>

Not enough ram. You should try running osm2pgsql with the slim option. It
uses much less ram but uses more disk space.

Emilie Laffray
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100719/546467b4/attachment.html>