From: Someone Date: Sat, 18 Oct 2025 17:08:25 +0000 (+0200) Subject: roles/base/backup/files X-Git-Tag: activeVersion X-Git-Url: https://git.somenet.org/root/pub/somesible.git/commitdiff_plain roles/base/backup/files --- diff --git a/roles/base/backup/files/default/backup.conf.managed b/roles/base/backup/files/default/backup.conf.managed index 2672b9b..0adea23 100644 --- a/roles/base/backup/files/default/backup.conf.managed +++ b/roles/base/backup/files/default/backup.conf.managed @@ -10,24 +10,24 @@ # # postgresql backup. -#backup_cmd "backup:POSTGRES/_GLOBAL_" "$(hostname -f)--POSTGRES" "sudo -u postgres -- pg_dumpall --globals-only" "-d13 -w7 -m24" "PASSPHRASE_CHANGEME" +#backup_cmd "backup:POSTGRES/_GLOBAL_" "$(hostname -f)--POSTGRES" "sudo -u postgres -- pg_dumpall --globals-only" "-d13 -w7 -m23" "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_cmd "backup:POSTGRES/$dbname" "$(hostname -f)--POSTGRES-$dbname" "sudo -u postgres -- pg_dump --clean --if-exists --create $dbname" "-d13 -w7 -m24" "PASSPHRASE_CHANGEME" +# backup_cmd "backup:POSTGRES/$dbname" "$(hostname -f)--POSTGRES-$dbname" "sudo -u postgres -- pg_dump --clean --if-exists --create $dbname" "-d13 -w7 -m23" "PASSPHRASE_CHANGEME" #done # mysql backup. #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_cmd "/bkp/storage-local/$(hostname -s)/MYSQL/$dbname" "$(hostname -f)--MYSQL-$dbname" "mysqldump --single-transaction --quick --add-drop-table --add-drop-trigger $dbname" "-d13 -w7 -m24" "PASSPHRASE_CHANGEME" +# backup_cmd "/bkp/storage-local/$(hostname -s)/MYSQL/$dbname" "$(hostname -f)--MYSQL-$dbname" "mysqldump --single-transaction --quick --add-drop-table --add-drop-trigger $dbname" "-d13 -w7 -m23" "PASSPHRASE_CHANGEME" #done # local backup. -#backup "/bkp/storage-local/$(hostname -s)/etc.enc" "$(hostname -f)" "/etc" "-d13 -w7 -m24" "PASSPHRASE_CHANGEME" -backup "/bkp/storage-local/$(hostname -s)/etc" "$(hostname -f)" "/etc" "-d13 -w7 -m24" -backup "/bkp/storage-local/$(hostname -s)/root" "$(hostname -f)" "/root" "-d13 -w7 -m24" -backup "/bkp/storage-local/$(hostname -s)/var" "$(hostname -f)" "/var" "-d13 -w7 -m24" -backup "/bkp/storage-local/$(hostname -s)/srv" "$(hostname -f)" "/srv" "-d13 -w7 -m24" +#backup "/bkp/storage-local/$(hostname -s)/etc.enc" "$(hostname -f)" "/etc" "-d13 -w7 -m23" "PASSPHRASE_CHANGEME" +backup "/bkp/storage-local/$(hostname -s)/etc" "$(hostname -f)" "/etc" "-d13 -w7 -m23" +backup "/bkp/storage-local/$(hostname -s)/root" "$(hostname -f)" "/root" "-d13 -w7 -m23" +backup "/bkp/storage-local/$(hostname -s)/var" "$(hostname -f)" "/var" "-d13 -w7 -m23" +backup "/bkp/storage-local/$(hostname -s)/srv" "$(hostname -f)" "/srv" "-d13 -w7 -m23" # remote backup.