[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