From bbd57a747348727cb8fbb4bbbe6b530d03707ec7 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Sun, 24 Dec 2023 22:37:59 +0100
Subject: Updated miniflux's docs

---
 content/docs/adyxax.org/miniflux/_index.md  |  8 ++++--
 content/docs/adyxax.org/miniflux/backups.md | 38 +++++++++++++++++++++++++++--
 2 files changed, 42 insertions(+), 4 deletions(-)

(limited to 'content/docs')

diff --git a/content/docs/adyxax.org/miniflux/_index.md b/content/docs/adyxax.org/miniflux/_index.md
index e71c3c1..43b8a11 100644
--- a/content/docs/adyxax.org/miniflux/_index.md
+++ b/content/docs/adyxax.org/miniflux/_index.md
@@ -5,10 +5,14 @@ description: miniflux.adyxax.org rss feed reader
 
 ## Introduction
 
-miniflux.adyxax.org is a [miniflux](https://miniflux.app/) instance that I have been using for about 5 years. It is a rss feed reader and aggregator written as a golang web application. It is a reliable piece of software and I never encountered any issue with it.
+miniflux.adyxax.org is a [miniflux](https://miniflux.app/) instance that I have been using for years. It is a rss feed reader and aggregator written as a golang web application. It is a reliable piece of software and I never encountered any issue with it.
 
 ## Captain's log
 
-- 2021-10-05 : migrated this instance to k3s on myth.adyxax.org
+- 2023-11-20 : migrated to nixos on myth.adyxax.org
+- 2023-10-26 : migrated to nixos on dalinar.adyxax.org
+- 2021-10-05 : migrated to k3s on myth.adyxax.org
+- circa 2018 : migrated to miniflux v2
+- circa 2016 : initial setup of miniflux v1
 
 ## Docs
diff --git a/content/docs/adyxax.org/miniflux/backups.md b/content/docs/adyxax.org/miniflux/backups.md
index 25d611d..79b66f3 100644
--- a/content/docs/adyxax.org/miniflux/backups.md
+++ b/content/docs/adyxax.org/miniflux/backups.md
@@ -5,7 +5,41 @@ description: Backups of miniflux.adyxax.org
 
 ## 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.
-- 
cgit v1.2.3