[OSM-talk] OSM-to-PostGIS issues

Juan Lucas Domínguez Rubio juan_lucas_dr at yahoo.com
Mon Jul 19 11:33:03 BST 2010


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



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


More information about the talk mailing list