[OSM-dev] Error importing Rusia OSM file - bad result during COPY

Adrian Chapela achapela.rexistros at gmail.com
Wed Jul 27 09:26:14 BST 2011


Hello,

I am trying to import a Russia OSM file. It is a big file (9.6 GB
uncompressed) and always its importing stop getting error:

COPY place, line 150689: "\N N 638786807 amenity restaurant
{"(\\"name\\",\\"€ВроПа\\")"} 100 \N \N \N \N \N \N \N \N \..."
Processing: Node(19140k) Way(0k) Relation(0)pgsql_nodes_set - bad result
during COPY, data 826700439 563726756 549332366 \N

I was looking about memory issues or ASCII related issues but I have
imported successfully Estonian file.

I have used this two commands to try to import the file:

osm2pgsql -lsc -C 2000 -O gazetteer -U postgres -d gazetteer russia.osm
osm2pgsql -lsc -C 500 -O gazetteer -U postgres -d gazetteer russia.osm

Also I have tried to import in a fresh database with the same result using:
osm2pgsql -las -C 2000 -O gazetteer -U postgres -d gazetteer russia.osm

Regards.



More information about the dev mailing list