Feature #2343
Updated by Alexander Watzinger 2 days ago
"Debian":https://www.debian.org/, the standard installation system for OpenAtlas, released the new version 13 "trixie":https://www.debian.org/releases/trixie/.
This issue provides information about the update and the new software versions being used with OpenAtlas, see comments for more details.
Branch: *feature/trixie*
* *Python* from *3.11.2* to *3.13.5* (changelog "3.12":https://docs.python.org/3/whatsnew/3.12.html, "3.13":https://docs.python.org/3/whatsnew/3.13.html)
* *Flask* from *2.2.2* to *3.1.1* ("changelogs":https://flask.palletsprojects.com/en/stable/changes/)
* *PostgreSQL* from *15* to *17* ("changelogs":https://www.postgresql.org/docs/release/)
* *Jinja2* from *3.1.2* to *3.1.6* ("changelogs":https://jinja.palletsprojects.com/en/stable/changes/)
*Compact instructions* for upgrading Debian 12 to 13 (trixie), see notes below for more details
* Backup everything, and specific for OpenAtlas:
** Your databases, e.g. with pg_dumpall for all PostgreSQL databases
** The folders at *files/uploads* for every instance
* Update current system
<pre><code class="bash">
sudo apt update && sudo apt full-upgrade -y
</code></pre>
* Change all occurrences of @bookworm@ to @trixie@ in /etc/apt/sources
<pre><code class="bash">
sudo apt edit-sources vim /etc/apt/sources
</code></pre>
* Upgrade - when prompted to upgrade PostgreSQL, choose **No** – the database will be upgraded manually later.
<pre><code class="bash">
sudo apt update && sudo apt upgrade --without-new-pkgs
sudo apt update && sudo apt upgrade --with-new-pkgs
</code></pre>
* Clean up
<pre><code class="bash">
sudo apt --purge autoremove -y
sudo apt autoclean
sudo cp -p /usr/lib/iipimage-server/iipsrv.fcgi /var/www/iipsrv/
</code></pre>
* Reboot the system
* PostgreSQL cluster upgrade
<pre><code class="bash">
sudo apt install postgresql-postgis
sudo systemctl stop postgresql
sudo pg_dropcluster 17 main
sudo pg_upgradecluster 15 main
sudo pg_dropcluster 15 main
sudo systemctl start postgresql
</code></pre>
As postgres user:
<pre><code class="bash">
reindexdb --all
</code></pre>
In case of collation warnings execute this SQL (replace openatlas in case you named it differently):
<pre><code class="sql">ALTER DATABASE openatlas REFRESH COLLATION VERSION;</code></pre>