Upgrade Postgres from 14 to 17 #1005
Description
Along the lines of #1004, Heroku sent out this message re: the prod server (our.terrastories.app):
Your database (COBALT on terrastories) is on the deprecated Postgres version 14 that will reach end-of-life on 2025-Nov-28. To ensure your database has the best performance, security, and features, we recommend you upgrade to the latest Postgres version. Upgrading to a supported version is necessary to maintain the integrity and reliability of your service. If you don’t upgrade your Postgres version by 2025-Oct-28, we'll upgrade your database version to Postgres 17. See Upgrading the Version of a Heroku Postgres Database for more details, or open a support ticket if you have any questions.
It would be good to test upgrading Postgres before Heroku does it. I'm not sure if there is anything that would break -- we don't use extensions like PostGIS for example -- but it would be very bad if our.terrastories.app goes down as it is the main (and currently only supported) way to use Terrastories.