Backups

Kein Backup, kein Mitleid!

restic
BBB-Docker

restic

After some searching arround i found restic as a solution.

It does file based backups has some sort of versioning, encrypts backups and restores permissions and ownership of data.

Following is how i set stuff up.

oh but dont forget ... RTFM

Szenario:

I do use a server for $stuff
I have a local Drive for Backups
I Drive is mounted to the local computer reachable via the internet (in my case a pi, lol)

Setup:

init repo: done on mashine to backup. basicly test if everything works on mashine storing the backup and init versioning/repo

1.1 init command
```
restic -r sftp://<USER>@<URL/IP>:<PORT>//media/HDD1/backups init
```
1.2 enter repo password: (you know note it down yada yada)

1.3 enter ssh key (i am using pubkey auth with encrypted ssh key)

1.4 if done correct you should see a success message ala created restic repository <ID>
(optional) alter ssh config for longer timeouts

2.1 open ~/.ssh/config

2.2 enter or alter
```
ServerAliveInterval 60
ServerAliveCountMax 240
```
setup to back up file

3.1 create file ala include_from.txt

3.2 specify folders to backup, for me following works:
```
/etc/**
/var/**
/home/**
/root/**
```
3.3 create file ala exclude_from.txt

3.4 specify folders to exclude, for me worked following
```
.cache
_cacache
```

Backup:

Prepare Machine where backups are stored:

1.1 plug drive in

1.2 mount drive
```
sudo mount /dev/sda1 /media/HDD1/
```

Run Backup (run as root!)

2.1 run command

restic -r sftp://<USER>@<URL/IP>:<PORT>//media/HDD1/backups backup --files-from /root/include_from.txt

2.2 enter ssh password

2.3 enter repo password

BBB-Docker

Backup Greenlight:

docker exec -t bbb-docker-postgres-1 pg_dumpall -c -U postgres > /root/greenlight_`date +%d-%m-%Y"_"%H_%M_%S`.sql

yay you have backup!

restore Backup

copy your backup to /$YOUR_INSTALL_OF_BBB-Docker/postgres_data
chmod so everyone can read

 docker exec -t bbb-docker-postgres-1 psql -U postgres -f /var/lib/postgresql/data/greenlight_06-07-2022_21_00_06.sql postgres

restart