Re: [OSM-talk] Fwd: Help Planet.osm.bz2 import error.
On 14 July 2011 00:49, Frederik Ramm frede...@remote.org wrote: No. That patch is for osm2pgsql-64 (with its support for 64bit IDs). Saphy Mo is running a plain old (more than 12 months old) 32-bit-id osm2pgsql on a Windows system. You yourself said that the 32bit version can crash if a way ends up in pending ways with nodes that have large ID numbers. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Fwd: Help Planet.osm.bz2 import error.
On 14 July 2011 10:11, John Smith deltafoxtrot...@gmail.com wrote: On 14 July 2011 00:49, Frederik Ramm frede...@remote.org wrote: No. That patch is for osm2pgsql-64 (with its support for 64bit IDs). Saphy Mo is running a plain old (more than 12 months old) 32-bit-id osm2pgsql on a Windows system. You yourself said that the 32bit version can crash if a way ends up in pending ways with nodes that have large ID numbers. AFAIK there is nothing that prevents node IDs causing an out of memory error, other than the fact that OSM for now has small ID numbers, Anthony's patch just checks to see how much memory is available and prevents osm2pgsql from using a memory cache if the memory is going to be exceeded. ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Fwd: Help Planet.osm.bz2 import error.
Can someone help this person out? -- Forwarded message -- From: Saphy Mo saphy...@yahoo.com Date: Jul 13, 2011 3:03 PM Subject: Help Planet.osm.bz2 import error. To: m...@rtijn.org m...@rtijn.org 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 Reagrds and thank. Saph ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Fwd: Help Planet.osm.bz2 import error.
On 13 July 2011 23:15, Martijn van Exel m...@rtijn.org wrote: Can someone help this person out? You might be hitting a memory limit, even though it's running on a 64 bit system it seems to be compiled on a 32 bit system, Anthony posted a patch to prevent exactly this sort of problem... http://lists.openstreetmap.org/pipermail/dev/2011-June/023002.html ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Fwd: Help Planet.osm.bz2 import error.
Hi, On 07/13/11 15:33, John Smith wrote: You might be hitting a memory limit, even though it's running on a 64 bit system it seems to be compiled on a 32 bit system, Anthony posted a patch to prevent exactly this sort of problem... http://lists.openstreetmap.org/pipermail/dev/2011-June/023002.html No. That patch is for osm2pgsql-64 (with its support for 64bit IDs). Saphy Mo is running a plain old (more than 12 months old) 32-bit-id osm2pgsql on a Windows system. As far as I know there is no version of osm2pgsql for 64-bit windows systems because ever since the autogen compile was introduced nobody managed to compile it properly. See http://wiki.openstreetmap.org/wiki/Osm2pgsql#Windows_XP. I think anyone who managed to compile a proper, current, 64bit version of osm2pgsql under Windows would be a hero for many ;) Bye Frederik ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Fwd: Help Planet.osm.bz2 import error.
On Wed, Jul 13, 2011 at 6:45 PM, Martijn van Exel m...@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 www.parveenarora.in E-Mail: m...@parveenarora.in ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Fwd: Help Planet.osm.bz2 import error.
On Wed, Jul 13, 2011 at 10:58 PM, Parveen Arora m...@parveenarora.in wrote: Have you tried o This complete line was: Have you tried to import country specific data? -- Parveen Arora www.parveenarora.in E-Mail: m...@parveenarora.in ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk