{"id":91,"date":"2017-02-22T10:29:25","date_gmt":"2017-02-22T10:29:25","guid":{"rendered":"https:\/\/blog.get-map.org\/?p=91"},"modified":"2017-02-22T10:45:47","modified_gmt":"2017-02-22T10:45:47","slug":"database-maintenance","status":"publish","type":"post","link":"https:\/\/blog.get-map.org\/index.php\/2017\/02\/22\/database-maintenance\/","title":{"rendered":"Database maintenance"},"content":{"rendered":"<p><a name=\"preamble\"><\/a> <\/p>\n<p>I&#8217;m going to do an OSM database reimport this weekend (Feb 25-26).<\/p>\n<p>The web frontend will be online most of the time, so existing maps can still be retrieved, and new rendering jobs can be created, but the rendering daemon will be offline for at least all of Saturday, probably most of Sunday, too.<\/p>\n<p>So don&#8217;t expect any new jobs entered over the weekend to be rendered before Monday, Feb. 27th, and the database may still be a bit behind for a few more days until things have fully caught up with minutely diffs again.<\/p>\n<p><!--more--><\/p>\n<p>The problem with the current import is that I used the hstore-match-only option. So objects from the planet file that don&#8217;t have any of the keys set that are put into distinct database columns defined by the osm2pgsql style file used will not be part of the resulting database even if a hstore column for general tag storage is available.<\/p>\n<p>This was not really what I had in mind, and it took a bit to figure out why the openPiste overlay, and the <a href=\"https:\/\/gitlab.com\/mvglasow\/pistemap\">Pistemap<\/a> style I&#8217;ve been experimenting with, did not show all ski piste segments. It turned out that these were the segments that only had &#8220;piste:*&#8221; tags on them, and not even a name or ref part, and that these were competely missing from the DB.<\/p>\n<p>For a moment I had considered to set up a separate DB for these for now, but in the end doing a new full import replacing the old database looks like the better way to go.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m going to do an OSM database reimport this weekend (Feb 25-26). The web frontend will be online most of the time, so existing maps can still be retrieved, and new rendering jobs can be created, but the rendering daemon will be offline for at least all of Saturday, probably most of Sunday, too. So &hellip; <a href=\"https:\/\/blog.get-map.org\/index.php\/2017\/02\/22\/database-maintenance\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Database maintenance&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/posts\/91"}],"collection":[{"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":1,"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":92,"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/posts\/91\/revisions\/92"}],"wp:attachment":[{"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.get-map.org\/index.php\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}