blob: 3af92a508f3cc1bae35a9a4c5bdc78e6442b5f73 (
plain) (
blame)
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
48
49
|
{
config,
pkgs,
...
}: {
services.restic.backups = let
snapshots = "/srv/snapshots";
boxUser = "u384702-sub2";
postgresUser = "postgres";
in {
storagebox = {
initialize = true;
backupPrepareCommand = ''
${pkgs.sudo}/bin/sudo -u ${postgresUser} ${pkgs.postgresql}/bin/pg_dumpall --clean --if-exists --quote-all-identifiers > /srv/db_backup.sql
[ -d /srv/snapshots/srv ] && ${pkgs.btrfs-progs}/bin/btrfs subvolume delete /srv/snapshots/srv;
${pkgs.btrfs-progs}/bin/btrfs subvolume snapshot -r /srv /srv/snapshots/srv;
# dump() {
# # compression:
# # pg_dump -F t -v "$1" | xz -z -9 -e -T0 > "db_$1.tar.xz"
# pg_dump -v "$1" > "db_$1.tar.xz"
# }
# # List all databases, and dump each of them in its own file
# # psql --list --csv | while read -r line; do echo "$line" | grep ','; done | while IFS=, read -r name _; do echo "$name"; done | sed '1d' | while read -r db_name; do dump "$db_name"; done
'';
paths = [
snapshots
];
exclude = [
".snapshots"
"/var/lib/postgresql" # included in the db dump
];
extraBackupArgs = [
"--verbose" # spam log
];
passwordFile = config.age.secrets.resticpass.path;
extraOptions = [
"rclone.program='ssh -p 23 ${boxUser}@${boxUser}.your-storagebox.de -i ${config.age.secrets.resticssh.path}'"
];
repository = "rclone: "; # There is only one repository served
timerConfig = {
Requires = "network-online.target";
OnCalendar = "daily";
Persistent = true;
};
};
};
}
|
