OpenAtlas

Feature #2343

Updated by Alexander Watzinger 3 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/) 
 * *PostGIS* from *3.3* to *3.5.2* 
 * *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@ *Node.js* from *18.13.0* to @trixie@ in /etc/apt/sources 
 <pre><code class="bash"> 
 sudo 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> *20.19.2*

Back