💾 Archived View for yaky.dev › notes › matrix-synapse captured on 2024-12-17 at 10:07:54. Gemini links have been rewritten to link to archived content

-=-=-=-=-=-=-

Matrix Synapse

Certificates

Renew Let's Encrypt TLS certificate without stopping nginx

certbot renew --webroot -w /path/to/webroot

Where /path/to/webroot is the same path that nginx serves the site on port 80, often /var/www or /srv/www.

See nginx config, it should be under something like

location / {
	root /srv/www;
}

PostgreSQL

List databases

psql --u admin_user --list

Vacuum (clean up) a database

vacuumdb --u admin_user db_name

Media

Delete media older than X days

This might delete avatars and other old files that are actively used.

find /var/lib/matrix-synapse/media/ -mtime -365 -delete

Links about cleaning up the DB

Compressing Synapse database

About state_groups_state

home

email me: hi@yaky.dev

CC BY-NC yaky.dev