Chat server: backup psql and convert to debian-testing

[jejb]

The current Ubuntu instance is ageing fast, so we should be on a rolling distribution, like debian testing, that already has a matrix server and takes care of upgrading it rather than us having to flounder around with pip install --upgrade every time plumbers rolls around.

[jejb]

The way I think we'll be able to do this is to backup the postgres database and restore it on the debian system (we can probably upgrade to the latest postgres at that time as well) and then simply point the matrix-synapse service to it. The only thing to beware of is that synaps can't do downgrades, so we need the version in debian testing to be equal to or greater than our current pip install (1.114.0)

[rppt]

Current version of matrix-synapse on debian-testing is 1.103.0-5

[aliceinwire]

current version of matrix-synapse is v1.114.0
matrix-synaps is also no more maintained by matrix but is now part of element-hq

[aliceinwire]

https://repology.org/project/matrix-synapse/versions

the few distribution that are updated are:

• Gentoo Linux
• Arch Linux (testing)
• Artix (testing)
• CRUX 3.7
• Exherbo
• LiGurOS
• Nix
• OpenBSD
• openSUSE Tumbleweed
• PyPI
• wikidata

[aliceinwire]

pypi looks the most updated as have even the development version of synpase 1.115.0rc1

[jejb]

The version of matrix in debian-testing is now 1.116:

https://tracker.debian.org/pkg/matrix-synapse

So we're clear to upgrade any time