Poddery - Diaspora, Matrix and XMPP: Difference between revisions
Add backup steps |
|||
| Line 453: | Line 453: | ||
$ ps -ef | grep receiver | $ ps -ef | grep receiver | ||
===Backup steps on 7th Jan 2025=== | |||
====Matrix-synapse==== | |||
For synapse, the following files were backed up: | |||
- Dump of postgresql using `pg_dump` | |||
- `/etc/matrix-synapse` | |||
- `/var/lib/static/synapse/media` | |||
In order to access the poddery server from the backup server (with your public ssh keys added to both the servers in `~/.ssh/authorized-keys`), run the following command in your local system: | |||
`eval "$(ssh-agent -s)"` | |||
followed by | |||
`ssh user@server -o "ForwardAgent yes" -o "AddKeysToAgent yes"` | |||
on the local system. | |||
The dump was taken using the command from the [https://element-hq.github.io/synapse/latest/usage/administration/backups.html#quick-and-easy-database-backup-and-restore official docs]: | |||
`ssh user@poddery-server 'sudo -u postgres pg_dump -Fc --exclude-table-data e2e_one_time_keys_json synapse' > poddery-backups/matrix-synapse/synapse-2025-01-07.dump` | |||
====Prosody==== | |||
The following were backed up for prosody: | |||
- Dump of the database using `mysqldump` | |||
- `/var/lib/prosody` for media files | |||
- `/etc/prosody` for config files | |||
For taking the dump, the following was run from the backup-server | |||
`ssh user@poddery-server 'mysqldump -u prosody --password="$(cat <path/to/password-file>)" prosody | gzip' > backups/prosody-backup-2024-10-27.sql.gz` | |||
= Troubleshooting = | = Troubleshooting = | ||