blob: edb3dcf8e7a4a1af84986e34a28015b02c703c87 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
---
title: "Backups"
description: Backups of miniflux.adyxax.org
tags:
- UpdateNeeded
---
## Documentation
Backups are configured with borg on `myth.adyxax.org` and end up on `gcp.adyxax.org`.
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.
|
