[OSM-talk] OSM-to-PostGIS issues

[Juan Lucas Domínguez Rubio]

Yes, sorry, here is the command and error message:

http://www.prodevelop.es/files/fm/public/downloads/wxp_console.png
 

Regards,
Juan Lucas


--- On Mon, 7/19/10, Graham Jones <grahamjones139 at googlemail.com> wrote:

From: Graham Jones <grahamjones139 at googlemail.com>
Subject: Re: [OSM-talk] OSM-to-PostGIS issues
To: "Juan Lucas Domínguez Rubio" <juan_lucas_dr at yahoo.com>
Date: Monday, July 19, 2010, 12:42 PM

Juan Lucas,I think you attached the wrong link - you have not attached the error message?
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).

Graham.

On 19 July 2010 11:33, 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/postgresql.conf.txt.

 
Any ideas why this happens?
Not enough RAM?
osm2pgsql is not Windows-friendly?
DB tuning needs double-checking?
Anybody has done this on WXP?
 
Regards,
Juan Lucas




      
_______________________________________________

talk mailing list

talk at openstreetmap.org

http://lists.openstreetmap.org/listinfo/talk





-- 
Dr. Graham Jones
Hartlepool, UK
email: grahamjones139 at gmail.com





      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20100719/4546bdbb/attachment.html>