Poddery - Diaspora, Matrix and XMPP: Difference between revisions

Line 456: Line 456:
===Backup steps on 7th Jan 2025===
===Backup steps on 7th Jan 2025===
====Matrix-synapse====
====Matrix-synapse====
For synapse, the following files were backed up:
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:
* Dump of postgresql database using `pg_dump`
* `/etc/matrix-synapse` - contains config files
* `/var/lib/static/synapse/media` -- contains uploaded media files


`eval "$(ssh-agent -s)"`
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:<syntaxhighlight lang="bash">
eval "$(ssh-agent -s)"
</syntaxhighlight>followed by<syntaxhighlight>
ssh user@server -o "ForwardAgent yes" -o "AddKeysToAgent yes"
</syntaxhighlight>on the local system.


followed by
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]:<syntaxhighlight>
 
ssh user@poddery-server 'sudo -u postgres pg_dump -Fc --exclude-table-data e2e_one_time_keys_json synapse' > synapse-2025-01-07.dump
`ssh user@server -o "ForwardAgent yes" -o "AddKeysToAgent yes"`
</syntaxhighlight>
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====
====Prosody====
The following were backed up for  prosody:
For backing up prosody, the following were copied:


* Dump of the database using `mysqldump`  
* Dump of the database using `mysqldump`