[OSM-talk] Fwd: Help Planet.osm.bz2 import error.

Parveen Arora mail at parveenarora.in
Wed Jul 13 18:28:08 BST 2011

On Wed, Jul 13, 2011 at 6:45 PM, Martijn van Exel <m at rtijn.org> 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
E-Mail: mail at parveenarora.in

More information about the talk mailing list