Hello everyone,
this night synapse did end to support the postgres 13 version.
So a patch script has been released with Libre Workspace Version 0.10.8 today with the following content:
cd /root/matrix
docker exec -it matrix-db-1 pg_dumpall -U synapse > ./upgrade_backup.sql
docker compose down
mv postgres-data postgres-data.old
# Change version from postgres 13 to 18 in docker compose yml
sed -i 's/image: postgres:13/image: postgres:18/' docker-compose.yml
# Change the mount to /var/lib/postgresql
sed -i 's| - ./postgres-data:/var/lib/postgresql/data| - ./postgres-data:/var/lib/postgresql|' docker-compose.yml
docker compose up -d db
sleep 10
cat ./upgrade_backup.sql | docker exec -i matrix-db-1 psql -U synapse -d synapse
docker exec matrix-db-1 psql -U synapse -d synapse -c "ALTER USER synapse WITH PASSWORD 'OoRei7oh';"
docker compose up -d
sleep 10
# Make sure element config is updated
. /etc/libre-workspace/libre-workspace.env
. /usr/lib/libre-workspace/modules/matrix/update_element_config.sh
It does a database upgrade to postgres version 18 and adjusts the mountpoint of the new postgres container as this is required with the 18+ versions. If your libre workspace has system updates enabled. The update will be applied this night.