[Tile-serving] [osm2pgsql] Can't import lasted planet.pbf (#241)

[Charly Blervacques]

Hi,

I try to import the entire latest planet in PostgreSQL database with osm2pgsql but I do not succeed
I first tried to import without the "-u" for the convertion of the old data in UTF-8.

But there's an error:
> Osm2pgsql failed due to ERROR: result COPY_END for planet_osm_line failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xb0
> CONTEXT:  COPY planet_osm_line, line 83590925

So I tried with the "-u" with no more success ...

__File :__
`planet-141203.osm.pbf `

__osm2pgsql :__ 
`osm2pgsql SVN version 0.87.0 (64bit id space)`

__Cmd :__
`osm2pgsql -c -d $db_name -P $db_port -U $db_user --slim -C 8000 -u -l -k -z -K --number processes 6 --flat-nodes $flat_nodes_path $planet_path`

__Result :__
> osm2pgsql SVN version 0.87.0 (64bit id space)
> 
> Using built-in tag processing pipeline
> Using projection SRS 4326 (Latlong)
> Setting up table: planet_osm_point
> Setting up table: planet_osm_line
> Setting up table: planet_osm_polygon
> Setting up table: planet_osm_roads
> Allocating memory for dense node cache
> Allocating dense node cache in one big chunk
> Allocating memory for sparse node cache
> Sharing dense sparse
> Node-cache: cache=8000MB, maxblocks=1024000*8192, allocation method=11
> Mid: loading persistent node cache from /corto/corto/osm/flat_nodes
> Allocated space for persistent node cache file
> Maximum node in persistent node cache: 0
> Mid: pgsql, scale=10000000 cache=8000
> Setting up table: planet_osm_nodes
> Setting up table: planet_osm_ways
> Setting up table: planet_osm_rels
> 
> Reading in file: /corto/corto/osm/planet-141203.osm.pbf
> Processing: Node(2631697k 730.4k/s) Way(262849k 1.28k/s) Relation(0 0.00/s)Maximum node in persistent node cache: 3217031167
> node cache: stored: 992702445(37.72%), storage efficiency: 94.67% (dense blocks: 925605, sparse nodes: 50378307), hit rate: 29.35%
> Osm2pgsql failed due to ERROR: result COPY_END for planet_osm_line failed: ERROR:  invalid byte sequence for encoding "UTF8": 0xb0
> CONTEXT:  COPY planet_osm_line, line 83590925


Do you know why this error occurs ?
Can you help me to import the planet, please ?

Thanks in advance :-)
Charly Blervacques.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/241
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20141229/80fb2af9/attachment-0001.html>