Message posté par : avel (avel.feron(a)gmail.com)
----------------------------------------
Bonjour à tous
Je suis en train d'importer ds postgresql/postgis un fichier osm.pbf. J'ai
l'erreur suivante qui apparait:
C:UsersFERON PAPEL Avel>osm2pgsql -U postgres -W -m -d osmBis -p osmBis -E 3857 -S
"C:ms4wtoolsosm2pgsqldefault.style" C:ms4wappsosmfrance-latest.osm.pbf
osm2pgsql version 0.96.0 (64 bit id space)
!! You are running this on 32bit system, so at most
!! 3GB of RAM can be used. If you encounter unexpected
!! exceptions during import, you should try running in slim
!! mode using parameter -s.
Password:
Allocating memory for sparse node cache
Node-cache: cache=800MB, maxblocks=12800*65536, allocation method=1
Using built-in tag processing pipeline
Using projection SRS 3857 (Spherical Mercator)
Setting up table: osmBis_point
node cache: stored: 0(-nan(ind)%), storage efficiency: -nan(ind)% (dense blocks: 0, sparse
nodes: 0), hit rate: -nan(ind)%
Osm2pgsql failed due to ERROR: CREATE UNLOGGED TABLE osmBis_point (osm_id
int8,"access" text,"addr:housename" text,"addr:housenumber"
text,"addr:interpolation" text,"admin_level"
text,"aerialway" text,"aeroway" text,"amenity"
text,"area" text,"barrier" text,"bicycle"
text,"brand" text,"bridge" text,"boundary"
text,"building" text,"capital" text,"construction"
text,"covered" text,"culvert" text,"cutting"
text,"denomination" text,"disused" text,"ele"
text,"embankment" text,"foot" text,"generator:source"
text,"harbour" text,"highway" text,"historic"
text,"horse" text,"intermittent" text,"junction"
text,"landuse" text,"layer" text,"leisure"
text,"lock" text,"man_made" text,"military"
text,"motorcar" text,"name" text,"natural"
text,"office" text,"oneway" text,"operator"
text,"place" text,"population" text,"power"
text,"power_source" text,"public_transport" text,"railway"
text,"ref" text,"religion" text,"route"
text,"service" text,"shop" text,"sport"
text,"surface" text,"toll" text,"touris
m" text,"tower:type" text,"tunnel" text,"water"
text,"waterway" text,"wetland" text,"width"
text,"wood" text,"z_order" int4,"population" text,way
geometry(POINT,3857) ) WITH ( autovacuum_enabled = FALSE ) failed: ERREUR: la colonne «
population ┬╗ est sp├®cifi├®e plus d'une fois
Queslqu'un a til eu déjà un pb similaire?
Merci beaucoup
----------------------------------------
Le message est situé
https://georezo.net/forum/viewtopic.php?pid=321496#p321496
Pour y répondre : webmapping(a)ml.georezo.net ou reply de votre messagerie
Pour vous désabonner connectez-vous sur le forum puis Profil / Abonnement
--
Association GeoRezo - le portail géomatique
https://georezo.net