Re: [OSM-dev] Osm2pgsql failure with low-end server

2011-12-16 Thread Andrew M. Bishop
Martijn van Oosterhout writes: > On 8 December 2011 11:13, Nick Whitelegg wrote: >> >>>700 MB is a tiny machine, but then the Finland data set isn't that large >>>either... it must be possible somehow ;) >> >> Incidentally why would it run out of memory in slim mode? I had the same >> problem to

Re: [OSM-dev] Osm2pgsql failure with low-end server

2011-12-11 Thread Frederik Ramm
Martijn, On 12/11/2011 02:31 PM, Martijn van Oosterhout wrote: And my final question was: why do polygons need post-processing after a normal import. I can't remember the reason... If they don't then we can solve the problem even quicker I would neither say the *need* postprocessing, nor a

Re: [OSM-dev] Osm2pgsql failure with low-end server

2011-12-11 Thread Martijn van Oosterhout
On 8 December 2011 11:13, Nick Whitelegg wrote: > >>700 MB is a tiny machine, but then the Finland data set isn't that large >>either... it must be possible somehow ;) > > Incidentally why would it run out of memory in slim mode? I had the same > problem too some time ago when trying to import the

Re: [OSM-dev] Osm2pgsql failure with low-end server

2011-12-08 Thread Nick Whitelegg
>700 MB is a tiny machine, but then the Finland data set isn't that large >either... it must be possible somehow ;) Incidentally why would it run out of memory in slim mode? I had the same problem too some time ago when trying to import the whole of England, back in the days before the county

Re: [OSM-dev] Osm2pgsql failure with low-end server

2011-12-08 Thread Frederik Ramm
Hi, On 12/08/2011 09:54 AM, Jukka Rahkonen wrote: processing way (68k) at 0.46k/sWARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exi

Re: [OSM-dev] Osm2pgsql failure with low-end server

2011-12-08 Thread Jukka Rahkonen
Frederik Ramm wrote: > Hi, > > On 12/08/2011 06:57 AM, Jukka Rahkonen wrote: >> processing way (68k) at 0.46k/sWARNING: terminating connection because >> of >> crash of another server process >> DETAIL: The postmaster has commanded this server process to roll back >> the >> current transaction an

Re: [OSM-dev] Osm2pgsql failure with low-end server

2011-12-08 Thread Frederik Ramm
Hi, On 12/08/2011 06:57 AM, Jukka Rahkonen wrote: processing way (68k) at 0.46k/sWARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exi

[OSM-dev] Osm2pgsql failure with low-end server

2011-12-07 Thread Jukka Rahkonen
Hi, I had a new try with importing Finnish osm excerpt with brand new osm2pgsql into PostgreSQL 8.4 on a very modest Linux server (700 Mb of memory). Import seems to be much faster in the beginning. It breaks still at the same place than with older osm2pgsql. Error seems to be something general se