[Tile-serving] [openstreetmap/osm2pgsql] Long import of Europe data file (#676)

Koles500 notifications at github.com
Sun Jan 22 20:22:32 UTC 2017


We want is to import Europe PBF file to database (from http://download.geofabrik.de). osm2pgsql is running now on our server for ~ 24 hours already processing Europe data..
`Processing: Node(1827652k 131.7k/s) Way(11431k 0.20k/s) Relation(0 0.00/s)`
Command I used:
`PS C:\OSM\rendering> osm2pgsql -U postgres -m -d osm -p osm -E 3857 -s -S C:\OSM\osm2pgsql\default.style C:\OSM\Data\europe-latest.osm.pbf`
Why is it so slow? I am a little worried that this may take very long time and who knows if this will work at the end or end up with some fucking error. We need this work to be done as soon as possible. It is running in slim mode. I had a look into Postgres database in PgAdmin III and I don't see any tables created like osm_nodes nor planet_osm_ways nor planet_osm_rels. Should they be there is place already? I clicked "refresh" on "Tables" so I think they should be there... or not ?
Before importing Europe I succeeded with importing a small irish town but this took just a moment. I am really impatient about this, because previous imports failed with Europe file, aldough at that time I used older version of osm2pgsql. Please help me find out if this working well or how to speed it up. Thanks.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/676
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170122/f596ef97/attachment.html>


More information about the Tile-serving mailing list