# Backups

Kein Backup, kein Mitleid!

# 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](https://restic.readthedocs.io/en/stable/010_introduction.html)

# 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:

1. 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
    ```sh
	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>`

2. (optional) alter ssh config for longer timeouts

	2.1 open ~/.ssh/config
    
    2.2 enter or alter
	```
    ServerAliveInterval 60
	ServerAliveCountMax 240
    ```
    
3. 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:

1. Prepare Machine where backups are stored:
	
    1.1 plug drive in
    
    1.2 mount drive
    ```sh
    sudo mount /dev/sda1 /media/HDD1/
    ```
    
2. Run Backup (run as root!)

	2.1 run command
	```sh
	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

1. copy your backup to `/$YOUR_INSTALL_OF_BBB-Docker/postgres_data`
2. chmod so everyone can read
3. ```
	docker exec -t bbb-docker-postgres-1 psql -U postgres -f /var/lib/postgresql/data/greenlight_06-07-2022_21_00_06.sql postgres
	```
4. restart