<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">I'm really not looking to invent new
      tools, just wondering which of the two documented approaches is
      the current best practice.</div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix">I'm quite content with the tool pulling
      the daily changes together for application and running multiple
      times to catch up with the month.  Especially if I can manage to
      streamline some other processes to get it down to weekly updates
      instead of monthly.</div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix">But thank for the response and
      suggestion.<br>
    </div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix">Lynn (D)<br>
    </div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix"><br>
    </div>
    <div class="moz-cite-prefix">On 4/15/2022 5:24 PM, Imre Samu wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAJnEWwkGQUn_shjix=-0g9X_24O95DWRghideOPqWcAr-At2_A@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">> "update in batches approximately monthly" 
        <div><br>
        </div>
        <div>in theory:  you can generate an osm change file from 2 osm
          monthly planet files [  <a
            href="https://planet.openstreetmap.org/pbf/"
            moz-do-not-send="true" class="moz-txt-link-freetext">https://planet.openstreetmap.org/pbf/</a> 
          ]</div>
        <div><br>
        </div>
        <div>example:</div>
        <div><font face="monospace">first import      :
            planet-220307.osm.pbf   ( in the database )<br>
          </font></div>
        <div><font face="monospace">next monthly batch:
            planet-220404.osm.pbf   ( planned import. )   </font></div>
        <div><br>
        </div>
        <div>And using <a
            href="https://docs.osmcode.org/osmium/latest/osmium-derive-changes.html"
            moz-do-not-send="true" class="moz-txt-link-freetext">https://docs.osmcode.org/osmium/latest/osmium-derive-changes.html</a>  </div>
        <div>you can create OSM change files from the two OSM monthly
          planet files.</div>
        <div><br>
        </div>
        <div><font face="monospace">osmium derive-changes
            planet-220307.osm.pbf planet-220404.osm.pbf -o <b>planet-diff-220307-220404.osc.bz2</b></font></div>
        <div><br>
        </div>
        <div>in theory,  the "planet-diff_220307_220404.osc.bz2" change
          file is smaller than the sum of ( daily changes files ) </div>
        <div><br>
        </div>
        <div>disclaimer:  in theory == not tested in real life.<br>
        </div>
        <div><br>
        </div>
        <div>regards,</div>
        <div>  Imre</div>
        <div><br>
        </div>
        <div><br>
        </div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">Lynn W. Deffenbaugh (Mr) <<a
            href="mailto:ldeffenb@homeside.to" moz-do-not-send="true"
            class="moz-txt-link-freetext">ldeffenb@homeside.to</a>>
          ezt írta (időpont: 2022. ápr. 14., Cs, 21:06):<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px
          0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Greetings
          fellow tile servers,<br>
          <br>
          I've just about finished (re)setting up my planet-wide tile
          server for <br>
          the umpteenth time and was wondering what is the current
          recommendation <br>
          for keeping the OSM database current. There are two different
          approaches <br>
          that I've found documented, and I've used both of them in the
          past.  But <br>
          for this newest server, I'd like to follow the best practice
          recommended <br>
          by the community.<br>
          <br>
          Using mod_tile's openstreetmap-tiles-update-expire from<br>
          <br>
          <a
            href="https://switch2osm.org/serving-tiles/updating-as-people-edit/"
            rel="noreferrer" target="_blank" moz-do-not-send="true"
            class="moz-txt-link-freetext">https://switch2osm.org/serving-tiles/updating-as-people-edit/</a><br>
          <br>
          or use osm2pgsql's osm2pgsql-replication from<br>
          <br>
          <a
href="https://osm2pgsql.org/doc/manual.html#updating-an-existing-database"
            rel="noreferrer" target="_blank" moz-do-not-send="true"
            class="moz-txt-link-freetext">https://osm2pgsql.org/doc/manual.html#updating-an-existing-database</a><br>
          <br>
          For a bit of background, I don't need minutely updates, but
          update in <br>
          batches approximately monthly using the daily planetary diffs.
          After <br>
          updating, I re-render all existing tiles that have been
          affected by the <br>
          updates (expired) and then snapshot the end resulting
          individual PNGs <br>
          (extracted from the metatiles directly) to another storage
          platform.<br>
          <br>
          Any/all comments are welcome.<br>
          <br>
          Lynn (D)<br>
          <br>
          <br>
          <br>
          _______________________________________________<br>
          Tile-serving mailing list<br>
          <a href="mailto:Tile-serving@openstreetmap.org"
            target="_blank" moz-do-not-send="true"
            class="moz-txt-link-freetext">Tile-serving@openstreetmap.org</a><br>
          <a
            href="https://lists.openstreetmap.org/listinfo/tile-serving"
            rel="noreferrer" target="_blank" moz-do-not-send="true"
            class="moz-txt-link-freetext">https://lists.openstreetmap.org/listinfo/tile-serving</a><br>
        </blockquote>
      </div>
    </blockquote>
    <p><br>
    </p>
  </body>
</html>