<div dir="ltr">Sold.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Feb 22, 2021 at 10:28 AM Darafei "Komяpa" Praliaskouski <<a href="mailto:me@komzpa.net">me@komzpa.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">We should follow the signals in the Postgres doc:<br><a href="https://www.postgresql.org/docs/13/server-shutdown.html" target="_blank">https://www.postgresql.org/docs/13/server-shutdown.html</a> <br><div><br></div><div>If someone wants fast shutdown they should issue a fast shutdown command which will trigger SIGINT which we handle. Recommended course of action is to change the shutdown method to fast rather than hacking postgis to support fast shutdown in smart mode.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Feb 22, 2021 at 9:18 PM Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">So, thanks to Sandro's good works over past years we have reasonable handling of interrupts embedded in PostGIS and back into busy areas of GEOS too. But, the interrupt signal we respect is SIGINT, which is what you can generate with a ctrl-C in psql or hitting the stop button in pgadmin. This is good and works. However, for system SHUTDOWN, the signal the system sends is SIGTERM and we do... nothing with that signal. So a shutdown can be paused until a statement completes, which can be quite a while.<br>
<br>
I'm not sure if we should interupt on SIGTERM. I am going back and forth just sitting here typing. I'm pretty sure PgSQL in general expects to allow all running statements to complete before shutting down, which implies not interrupting on SIGTERM. On the other hand, PgSQL has this OLTP assumption pretty deeply built in that most statements just aren't expected to last very long. <br>
<br>
Relevant ticket is here <a href="https://trac.osgeo.org/postgis/ticket/4857#comment:5" rel="noreferrer" target="_blank">https://trac.osgeo.org/postgis/ticket/4857#comment:5</a><br>
<br>
Opinions solicited.<br>
<br>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr">Darafei "Komяpa" Praliaskouski<br>OSM BY Team - <a href="http://openstreetmap.by/" target="_blank">http://openstreetmap.by/</a><br></div></div>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a><br>
</blockquote></div>