[OSM-dev] osm2pgsql wont work with planet

[Jon Burgess]

On Fri, 2009-07-10 at 17:41 +0200, Matthias Sala wrote:
> Hello there
> 
> Lately, I set up a new tile server at Hetzner to mapnik-render the whole
> planet.
> 
> I use:
> * postgres 8.3
> * Ubuntu 8.10 minimal
> * self-compiled osm2pgsql
> 
> When using the osm2pgsql command to import the planet file, the following
> occurs:
> 
>  $ time ./osm2pgsql --slim -m -d gis planet-090708.osm.bz2
>  
>  StartElement: Unknown element name: changeset
>  EndElement: Unknown element name: changeset
>  .
>  . // several screens full of this
>  .
>  StartElement: Unknown element name: changeset
>  EndElement: Unknown element name: changeset
>  Entity: line 4315: parser error : AttValue: ' expected
>  "4312" created_at="2008-04-01T13:19:11Z" closed_at="2008-04-01T14:19:11Z"
> open="
>  
> ^
>  Entity: line 4315: parser error : attributes construct error
>  "4312" created_at="2008-04-01T13:19:11Z" closed_at="2008-04-01T14:19:11Z"
> open="
>  
> ^
>  Entity: line 4315: parser error : Couldn't find end of Start Tag changeset
>  "4312" created_at="2008-04-01T13:19:11Z" closed_at="2008-04-01T14:19:11Z"
> open="
>  
> ^
>  ../../planet-090708.osm.bz2 : failed to parse
>  Error occurred, cleaning up
> 
> Why is that?
> 
> The planet file is md5sum checked, downloaded from
> http://planet.openstreetmap.org/planet-latest.osm.bz2
> I also switched off autovacuum.
> The whole process works completely fine with the switzerland.osm.bz2
> 
> I guess the 1 GB RAM on the server are not insufficient, right?

When did you compile osm2pgsql? Both these issues look like ones which
were fixed a little while ago in SVN.

Please update to the latest SVN code and try again.

With only 1GB of RAM you'll need to use the --slim option to have a
chance of making it work. You should also not install the intarray
module into postgresql otherwise the index creation will probably take
more than a week (this prevents you applying diffs).

	Jon