I want to import several city extracts from the bbike website into my postgis database. I use windows on a desktop pc with 16GB RAM and a quadcore processor. The first couple of extracts imported fairly well. I used this command:

osm2pgsql --append -s --database <database>--username <username> <path to pbf>

After around 10 extracts the import looks like it stopped (Speed 0.0k) without any error message or it is extremely slow. When I add the cache flag and set it to 12000 it has now effect.

Looking at pgadmin there still seems to be activity on the db. This is what my pgAdmin panel looks like:

enter image description here

Did anyone experience the same and got a solution? What could be the reason for this?

  • From my 1TB harddrive roughly half of it is full. Should have 400GB + still free. – Chris P Nov 29 '18 at 8:59
  • 2
    Is Postgres working "hard" in the background? It may be rebuilding the indexes, which will take longer and longer as the DB size increase. You may want to play with PG configuration to give it more resources (like maintenance_work_mem) during the load – JGH Nov 29 '18 at 12:30
  • I added a screenshot from my pgAdmin panel. It seems like the amount of processed nodes is rising very slowly while speed is indicated at 0.0k. But with this speed even the import of one single city extract would take forever. How can I figure out whether the indexes are the reason for that? – Chris P Nov 29 '18 at 20:40
  • 1
    It seems like that --append is the problem. It is not meant to do what I think it does. I found the following question and the comments might explain my problem: gis.stackexchange.com/questions/294037/… – Chris P Nov 30 '18 at 8:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.