Hi all

I have imported the Europe dataset in PostgreSQL with osm2pgsql, and I apply daily updates with a routine every night. Looking at the logs I keep, I believe one of the daily updates was not correctly applied. I was thinking about simply re-playing those updates (edit : all the daily updates since the failure, of course). Would this work ? From what I understand of the way osm2pgsql works it basically does inserts and deletes, so I'd say this could work, but I'd rather be sure.

Thanks for your help on this !

asked 05 Mar, 07:55

codata_al's gravatar image

codata_al
162
accept rate: 0%

edited 05 Mar, 08:38


osm2pgsql's update process is safe to replay. That means you can repeat updates provided you reapply all updates from the date that the update process failed and you apply them in the correct order. The database is only back to a consistent state when all updates have been processed.

permanent link

answered 05 Mar, 11:44

lonvia's gravatar image

lonvia
5.1k14976
accept rate: 39%

edited 05 Mar, 12:07

SomeoneElse's gravatar image

SomeoneElse ♦
31.3k63322726

That's excellent news Lonvia !

Thanks for your help !

(05 Mar, 12:07) codata_al
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×188

question asked: 05 Mar, 07:55

question was seen: 111 times

last updated: 05 Mar, 12:07

powered by OSQA