From 06b86e88e35e75586e63ca859279cbcc1336699b Mon Sep 17 00:00:00 2001 From: Someone Date: Sat, 10 Jan 2026 02:51:39 +0100 Subject: [PATCH] roles/base/backup/files --- .../backup/files/default/backup.conf.managed | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/roles/base/backup/files/default/backup.conf.managed b/roles/base/backup/files/default/backup.conf.managed index f7f9f69..ea52417 100644 --- a/roles/base/backup/files/default/backup.conf.managed +++ b/roles/base/backup/files/default/backup.conf.managed @@ -12,32 +12,32 @@ # # TODO: after 2027-01-01: get rid of "folder names *2" -# postgresql backup. -#backup_cmd2 "backup:POSTGRES/_GLOBAL_" "$(hostname -f)--POSTGRES" "sudo -u postgres -- pg_dumpall --globals-only" "-d13 -w7 -m29" "PASSPHRASE_CHANGEME" +# postgresql backup +#backup_cmd2 "ssh://backup/POSTGRES/_GLOBAL_" "$(hostname -f)--POSTGRES" "sudo -u postgres -- pg_dumpall --globals-only" "-d13 -w7 -m29" "PASSPHRASE_CHANGEME" #for dbname in `echo "SELECT datname FROM pg_database WHERE datname not in ('template0', 'template1', 'postgres') AND datname not ilike '%_NOBKP' ORDER BY datname" | sudo -u postgres psql -A -P tuples_only=true` ; do -# backup_cmd2 "backup:POSTGRES/$dbname" "$(hostname -f)--POSTGRES-$dbname" "sudo -u postgres -- pg_dump --clean --if-exists --create $dbname" "-d13 -w7 -m29" "PASSPHRASE_CHANGEME" +# backup_cmd2 "ssh://backup/POSTGRES/$dbname" "$(hostname -f)--POSTGRES-$dbname" "sudo -u postgres -- pg_dump --clean --if-exists --create $dbname" "-d13 -w7 -m29" "PASSPHRASE_CHANGEME" #done -# mysql backup. +# mysql backup (borgbackup 1) #for dbname in `echo "select distinct TABLE_SCHEMA from information_schema.tables where TABLE_SCHEMA not in ('information_schema', 'performance_schema', 'sys');" | mysql -B --column-names=false` ; do # backup_cmd2 "/bkp/storage-local/$(hostname -s)/MYSQL/$dbname" "$(hostname -f)--MYSQL-$dbname" "mysqldump --single-transaction --quick --add-drop-table --add-drop-trigger $dbname" "-d13 -w7 -m29" "PASSPHRASE_CHANGEME" #done -# local backup. (borgbackup 1) +# local backup (borgbackup 1) #backup "/bkp/storage-local/$(hostname -s)/etc.enc" "$(hostname -f)" "/etc" "-d13 -w7 -m29" "PASSPHRASE_CHANGEME" #backup "/bkp/storage-local/$(hostname -s)/etc" "$(hostname -f)" "/etc" "-d13 -w7 -m29" #backup "/bkp/storage-local/$(hostname -s)/root" "$(hostname -f)" "/root" "-d13 -w7 -m29" #backup "/bkp/storage-local/$(hostname -s)/var" "$(hostname -f)" "/var" "-d13 -w7 -m29" #backup "/bkp/storage-local/$(hostname -s)/srv" "$(hostname -f)" "/srv" "-d13 -w7 -m29" -# local backup2. +# local backup2 #backup2 "/bkp/storage-local/$(hostname -s)/etc.enc2" "$(hostname -f)" "/etc" "-d13 -w7 -m29" "PASSPHRASE_CHANGEME" backup2 "/bkp/storage-local/$(hostname -s)/etc2" "$(hostname -f)" "/etc" "-d13 -w7 -m29" backup2 "/bkp/storage-local/$(hostname -s)/root2" "$(hostname -f)" "/root" "-d13 -w7 -m29" backup2 "/bkp/storage-local/$(hostname -s)/var2" "$(hostname -f)" "/var" "-d13 -w7 -m29" backup2 "/bkp/storage-local/$(hostname -s)/srv2" "$(hostname -f)" "/srv" "-d13 -w7 -m29" -# remote backup. -#backup2 "backup:home" "$(hostname -f)" "/home" "-d13 -w7 -m6" +# remote backup +#backup2 "ssh://backup/home" "$(hostname -f)" "/home" "-d13 -w7 -m6" -- 2.47.3