borgmatic-production

Backup

Create remote repo

chwon user:user repo directory .

borg init --encryption=none app2@ip-address:/data/backup/app2/ems.bitsathy.ac.in-repo  

Create borgmatic.yaml in source folder

Refer Borg/usr/local/bin/borgmatic -c borgmatic.yaml/borgmatic.yaml

Create staging dir

mkdir /data/staging/ems.bitsathy.ac.in/pg_dump

For pgsql dump

- sudo -u postgres pg_dump -F p -f - bip_baps >  /data/staging/bip.bapssathy.ac.in/pg_dump/bip_baps.sql  

For mysql dump

- mysqldump --order-by-primary --routines --triggers --events --single-transaction --databases baps --result-file=/data/staging/bip.bapssathy.ac.in/mysqldump/baps.sql

Add healthcheck

  - wget --no-check-certificate "https://hc.bit.lan/ping/3b35475a-d906-432f-a530-adaee777c8fc"   

Run borgmatic

/usr/local/bin/borgmatic -c borgmatic.yaml