On Wed, Jul 13, 2011 at 6:45 PM, Martijn van Exel <[email protected]> wrote: > Dear Sir van Excel, > I have got error as out of memory at the end of import of newest Planet.osm > into postgis database using osm2pgsql.exe. in slim mode. > could you please give me some tips to by pass this problem? > I used this command: > osm2pgsql.exe -d PlanetLL --latlong --slim -c -C 1500 -H localhost -P 5432 > -U osm -W -S default.style .\OsmFiles\Planet-Latest.osm.bz2 > in postgresql Server the configuration is as: > shared_buffers = 260MB
Have you tried o Do you really need the whole planet file along with all the data, If not you can process the file according to your requirement or also can refine the data. There are also some other configuration recommended along with shared_buffers. i.e. checkpoint_segments = 20 maintenance_work_mem = 256MB # 256000 for 8.1 and earlier autovacuum = off But If you require the whole data and osm2pgsql for windows is not doing task then you should try any other tool like Osmosis etc. to generate the tiles. -- Parveen Arora www.parveenarora.in E-Mail: [email protected] _______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk
