diff options
Diffstat (limited to 'content/docs/adyxax.org/miniflux/backups.md')
| -rw-r--r-- | content/docs/adyxax.org/miniflux/backups.md | 40 |
1 files changed, 38 insertions, 2 deletions
diff --git a/content/docs/adyxax.org/miniflux/backups.md b/content/docs/adyxax.org/miniflux/backups.md index 25d611d..edb3dcf 100644 --- a/content/docs/adyxax.org/miniflux/backups.md +++ b/content/docs/adyxax.org/miniflux/backups.md @@ -1,11 +1,47 @@ --- title: "Backups" description: Backups of miniflux.adyxax.org +tags: +- UpdateNeeded --- ## Documentation -Backups are configured with borg on `myth.adyxax.org` to `yen.adyxax.org`. +Backups are configured with borg on `myth.adyxax.org` and end up on `gcp.adyxax.org`. -There is only on jobs : +There is only one jobs : - a pg_dump of miniflux's postgresql database + +## How to restore + +The first step is to deploy miniflux to the destination server, then I need to login with ssh and manually restore the data. +```sh +make run host=myth.adyxax.org +``` + +The container will be failing because no password is set on the database user yet, so stop it: +```sh +systemctl stop podman-miniflux +``` + +There is only one backup job for miniflux. It contains a dump of the database: +```sh +export BORG_RSH="ssh -i /etc/borg-miniflux-db.key" +borg list ssh://borg@gcp.adyxax.org/srv/borg/miniflux-db +borg extract ssh://borg@gcp.adyxax.org/srv/borg/miniflux-db::dalinar-miniflux-db-2023-11-20T00:00:01 +psql -h localhost -U postgres -d miniflux +``` + +Restoring the data itself is done with the psql shell: +```sql +ALTER USER miniflux WITH PASSWORD 'XXXXXX'; +\i tmp/miniflux.sql +``` + +Afterwards clean up the database dump and restart miniflux: +```sh +rm -rf tmp/ +systemctl start podman-miniflux +``` + +To wrap this up, migrate the DNS records to the new host and update the monitoring system. |