Alright, update here - Found this post which is wonderful and got me what I needed from a backup perspective (Still need to practice the restore function, but I’ll cross that bridge later)
Which installation type did you use?
Standalone.
dhis2-tools-ng
dhis2-server-tools - Ansible
Nevertheless, you can automate the backup or manually.
Manual backup if you have access to the database server
$ pg_dump -T analytics_* -T aggregated* -T completeness* -O -x database_name | gzip > name_backup_.sql.gz
Auto backup
To back up your DHIS2 database using a cron job in PostgreSQL, you can follow these steps:
Create a backup script: Start by creating a shell script that will execut…
Also see here for my commands on how I’m running my software update.
Awesome, found time to run this update on a test server. I’ll follow up in a month or 2 if this fixed our issue.
Version 2.38.3.1
Build revision 0339321
Build date April 14, 2023 at 14:13
Jasper reports version 6.18.1
User agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/113.0
Server date May 23, 2023 at 23:08
Last analytics table generation May 23, 2023 at 21:00
Time since last analytics table generation 2 h, 8 m, 59 s
Last analytics table runtime 00:00:17.0…
cd /home/dhis/
sudo -u dhis tomcat-dhis/bin/shutdown.sh
cd ~
sudo -u postgres pg_dump -T analytics_* -T aggregated* -T completeness* -O -x dhis2 | gzip > 2023-05-27_dhis2_database_backup.sql.gz
cd /home/dhis/
sudo wget https://releases.dhis2.org/2.38/dhis2-stable-2.38.3.1.war
sudo mv dhis2-stable-2.38.3.1.war /home/dhis/tomcat-dhis/webapps/ROOT.war
sudo -u dhis /home/dhis/tomcat-dhis/bin/startup.sh