<!DOCTYPE html><html><head><title></title><style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi,<br></div><div><br></div><div>If you know the list of tiles that have expired, can't you script deleting these, and then regenerate the cache?<br></div><div>mapcache_seed should skip generating any existing tiles. I'm unaware of any inbuilt way of doing this. <br></div><div>There is a RFC at <a href="https://mapserver.org/development/rfc/ms-rfc-122.html">https://mapserver.org/development/rfc/ms-rfc-122.html</a> that may be of interest/relevance to you in the future.<br></div><div><br></div><div>Seth<br></div><div><br></div><div><br></div><div><br></div><div id="sig62266145"><div class="signature">--<br></div><div class="signature">web:http://geographika.co.uk<br></div><div class="signature">twitter: @geographika<br></div></div><div><br></div><div><br></div><div>On Sat, Jul 27, 2019, at 6:52 AM, parsis presswala wrote:<br></div><blockquote type="cite" id="qt"><div dir="ltr"><div style="font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;padding-top:0px;padding-right:15px;padding-bottom:0px;padding-left:0px;border-top-color:currentcolor;border-top-style:none;border-top-width:0px;border-right-color:currentcolor;border-right-style:none;border-right-width:0px;border-bottom-color:currentcolor;border-bottom-style:none;border-bottom-width:0px;border-left-color:currentcolor;border-left-style:none;border-left-width:0px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial, "Helvetica Neue", Helvetica, sans-serif;vertical-align:top;box-sizing:inherit;width:auto;color:rgb(36, 39, 41);background-color:rgb(249, 248, 246);" class="qt-gmail-m_-4088556003608738325gmail-votecell qt-gmail-m_-4088556003608738325gmail-post-layout--left"><div style="padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;border-top-color:currentcolor;border-top-style:none;border-top-width:0px;border-right-color:currentcolor;border-right-style:none;border-right-width:0px;border-bottom-color:currentcolor;border-bottom-style:none;border-bottom-width:0px;border-left-color:currentcolor;border-left-style:none;border-left-width:0px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;font-style:inherit;font-variant-caps:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-variant-ligatures:inherit;font-variant-numeric:inherit;font-variant-position:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit;display:flex;color:rgb(187, 192, 196);" class="qt-gmail-m_-4088556003608738325gmail-js-voting-container qt-gmail-m_-4088556003608738325gmail-grid qt-gmail-m_-4088556003608738325gmail-fd-column qt-gmail-m_-4088556003608738325gmail-ai-stretch qt-gmail-m_-4088556003608738325gmail-gs4 qt-gmail-m_-4088556003608738325gmail-fc-black-200"><div style="margin-top:2px;margin-right:2px;margin-bottom:2px;margin-left:2px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;border-top-color:currentcolor;border-top-style:none;border-top-width:0px;border-right-color:currentcolor;border-right-style:none;border-right-width:0px;border-bottom-color:currentcolor;border-bottom-style:none;border-bottom-width:0px;border-left-color:currentcolor;border-left-style:none;border-left-width:0px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;font-style:inherit;font-variant-caps:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-variant-ligatures:inherit;font-variant-numeric:inherit;font-variant-position:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit;display:flex;font-size:1.61538rem;color:rgb(106, 115, 124);" class="qt-gmail-m_-4088556003608738325gmail-js-vote-count qt-gmail-m_-4088556003608738325gmail-grid--cell qt-gmail-m_-4088556003608738325gmail-fc-black-500 qt-gmail-m_-4088556003608738325gmail-fs-title qt-gmail-m_-4088556003608738325gmail-grid qt-gmail-m_-4088556003608738325gmail-fd-column qt-gmail-m_-4088556003608738325gmail-ai-center"><span style="color:rgb(36, 39, 41)" class="colour"><span style="font-family:inherit" class="font"><span style="font-size:15px" class="size"><span style="font-family:inherit" class="font">I have developed the map using MapServer and pre-generated tile using mapcache. Now I have an idea to update the database every day. As changes apply in the database only those parts should be re-render and new tile should be generated. As changes are very small and rendering all ties from start is difficult to process.</span><br></span></span></span><span style="color:rgb(36, 39, 41)" class="colour"><span style="font-family:inherit" class="font"><span style="font-size:15px" class="size"></span></span></span></div></div></div><div style="font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;border-top-color:currentcolor;border-top-style:none;border-top-width:0px;border-right-color:currentcolor;border-right-style:none;border-right-width:0px;border-bottom-color:currentcolor;border-bottom-style:none;border-bottom-width:0px;border-left-color:currentcolor;border-left-style:none;border-left-width:0px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Arial, "Helvetica Neue", Helvetica, sans-serif;vertical-align:top;box-sizing:inherit;width:auto;min-width:0px;background-color:rgb(249, 248, 246);" class="qt-gmail-m_-4088556003608738325gmail-postcell qt-gmail-m_-4088556003608738325gmail-post-layout--right"><div style="margin-top:0px;margin-right:0px;margin-bottom:5px;margin-left:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;border-top-color:currentcolor;border-top-style:none;border-top-width:0px;border-right-color:currentcolor;border-right-style:none;border-right-width:0px;border-bottom-color:currentcolor;border-bottom-style:none;border-bottom-width:0px;border-left-color:currentcolor;border-left-style:none;border-left-width:0px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;font-style:inherit;font-variant-caps:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-variant-ligatures:inherit;font-variant-numeric:inherit;font-variant-position:inherit;font-weight:inherit;font-stretch:inherit;line-height:1.3;font-size:15px;vertical-align:baseline;box-sizing:inherit;width:675px;" class="qt-gmail-m_-4088556003608738325gmail-post-text"><p style="margin: 0px 0px 1em; padding: 0px; border: 0px none; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; vertical-align: baseline; box-sizing: inherit; clear: both;"><span style="color:rgb(36, 39, 41)" class="colour"><span style="font-family:inherit" class="font">I got expiry list of tiles by following osm2pgsql:</span></span><br></p><p style="margin: 0px 0px 1em; padding: 0px; border: 0px none; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; vertical-align: baseline; box-sizing: inherit; clear: both;"><span style="font-family:inherit" class="font"><span style="color:#444444" class="colour"><span style="background-color:rgb(239, 240, 241)" class="highlight"><span style="font-family:inherit" class="font"><span style="font-size:13px" class="size">osm2pgsql </span></span></span><span style="background-color:rgb(239, 240, 241)" class="highlight"><span style="font-family:inherit" class="font"><span style="font-size:13px" class="size">--append --slim --cache 1000 --multi-geometry /home/parsis/diff_file_minute.xml --number-processes 2 --hstore -d testdemo -r xml -e6-11 -o /home/parsis/expire.list</span></span></span></span></span><br></p><p style="margin: 0px 0px 1em; padding: 0px; border: 0px none; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; vertical-align: baseline; box-sizing: inherit; clear: both;"><span style="font-family:inherit" class="font"><span style="color:rgb(36, 39, 41)" class="colour">Got list something like this:</span></span><br></p><pre style="white-space:pre-wrap;margin-top:0px;margin-bottom:1em;padding-top:12px;padding-right:8px;padding-bottom:12px;padding-left:8px;border-top-color:currentcolor;border-top-style:none;border-top-width:0px;border-right-color:currentcolor;border-right-style:none;border-right-width:0px;border-bottom-color:currentcolor;border-bottom-style:none;border-bottom-width:0px;border-left-color:currentcolor;border-left-style:none;border-left-width:0px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;font-family:Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif;font-size:13px;vertical-align:baseline;box-sizing:inherit;width:auto;max-height:600px;overflow-x:auto;overflow-y:auto;background-color:rgb(239, 240, 241);border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;color:rgb(57, 51, 24);" class="qt-gmail-m_-4088556003608738325gmail-lang-sql qt-gmail-m_-4088556003608738325gmail-prettyprint qt-gmail-m_-4088556003608738325gmail-prettyprinted"><code style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;border-top-color:currentcolor;border-top-style:none;border-top-width:0px;border-right-color:currentcolor;border-right-style:none;border-right-width:0px;border-bottom-color:currentcolor;border-bottom-style:none;border-bottom-width:0px;border-left-color:currentcolor;border-left-style:none;border-left-width:0px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;font-style:inherit;font-variant-caps:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-variant-ligatures:inherit;font-variant-numeric:inherit;font-variant-position:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif;vertical-align:baseline;box-sizing:inherit;white-space:inherit;"><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font"> - </span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">11</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">/</span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">329</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">/</span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">713</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">
</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">-</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font"> </span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">8</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">/</span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">40</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">/</span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">91</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">
</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">-</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font"> </span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">10</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">/</span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">164</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">/</span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">357</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">
</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">-</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font"> </span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">7</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">/</span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">29</span></span><span style="color:rgb(48, 51, 54)" class="colour"><span style="font-family:inherit" class="font">/</span></span><span style="color:rgb(125, 39, 39)" class="colour"><span style="font-family:inherit" class="font">47</span></span></code><br></pre><p style="margin: 0px 0px 1em; padding: 0px; border: 0px none; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; vertical-align: baseline; box-sizing: inherit; clear: both;"><span style="color:rgb(36, 39, 41)" class="colour">I find another approach using <a style="color:rgb(29, 77, 92);margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;border-top-color:currentcolor;border-top-style:none;border-top-width:0px;border-right-color:currentcolor;border-right-style:none;border-right-width:0px;border-bottom-color:currentcolor;border-bottom-style:none;border-bottom-width:0px;border-left-color:currentcolor;border-left-style:none;border-left-width:0px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;font-style:inherit;font-variant-caps:inherit;font-variant-alternates:inherit;font-variant-east-asian:inherit;font-variant-ligatures:inherit;font-variant-numeric:inherit;font-variant-position:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit;" href="https://ircama.github.io/osm-carto-tutorials/manpage.html?url=https://rawgit.com/openstreetmap/mod_tile/master/docs/render_expired.1" rel="nofollow noreferrer">render_expired</a>, but don't know how to use it with mapcache.</span><br></p><p style="margin: 0px 0px 1em; padding: 0px; border: 0px none; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; vertical-align: baseline; box-sizing: inherit; clear: both;"><span style="color:rgb(36, 39, 41)" class="colour">How is it possible using mapcache_seed?</span><br></p></div></div></div><div>_______________________________________________<br></div><div>mapserver-dev mailing list<br></div><div>mapserver-dev@lists.osgeo.org<br></div><div>https://lists.osgeo.org/mailman/listinfo/mapserver-dev<br></div></blockquote><div><br></div></body></html>