<div dir="auto">I ended up doing a pg_dump on Debian 8.9 and a pg_restore on Debian 9 when I upgraded.<div dir="auto"><br></div><div dir="auto">Debian makes an effort to keep the old PosrgreSQL version installed after the OS upgrade so people can switch to the new DB version later.  Unfortunately, this time it appears they forgot about keeping the old PostGIS version along with it.  (And it doesn't seem trivial to just copy the old postgis library back because of dependancy issues).</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Aug 11, 2017 5:05 AM, "Pietro Rossin" <<a href="mailto:pietro.rossin@arpa.fvg.it">pietro.rossin@arpa.fvg.it</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I guess this is the best way to go...<br>
<br>
<a href="https://postgis.net/docs/postgis_installation.html#hard_upgrade" rel="noreferrer" target="_blank">https://postgis.net/docs/<wbr>postgis_installation.html#<wbr>hard_upgrade</a><br>
<br>
<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://postgis.17.x6.nabble.com/Upgrade-both-Postgres-postgis-and-Debian-major-releases-how-to-tp5011462p5011465.html" rel="noreferrer" target="_blank">http://postgis.17.x6.nabble.<wbr>com/Upgrade-both-Postgres-<wbr>postgis-and-Debian-major-<wbr>releases-how-to-<wbr>tp5011462p5011465.html</a><br>
Sent from the PostGIS - User mailing list archive at Nabble.com.<br>
______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a></blockquote></div></div>