I accidentally torched the Matrix DB this evening and moved to a new server as a result. You will need new credentials; please reach out.
I saw Synapse deprecate support for Postgres 13. We were running Postgres 14. I figured since I had some free time, I’d go ahead and update Postgres to latest today so I wouldn’t have pressure to upgrade it when 14 got deprecated. I did some research on the state of the art for Postgres major version upgrades and found pg_upgrade. I found a blog post detailing how to use pg_upgrade. It recommended pg_dropcluster main --stop which sounded like it’d delete the data; in the line below, the post says this won’t delete data. I ran it and found the data deleted. I restored my DigitalOcean droplet from backup. This did not bring the data back. DigitalOcean droplets do not contain data from any attached volumes.
Being out of luck, I started setting up Tuwunel on my local Kubernetes cluster. This will require us to get new credentials but will remove my additional monthly hosting costs, make database backups and other operations concerns easier, and dramatically increase performance as felt by Matrix clients.
