diff options
author | Ivan Kohler <ivan@freeside.biz> | 2021-08-10 11:31:02 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2021-08-10 11:31:02 -0700 |
commit | d6e22939c76c15fe97a298ff2a57b1154d89438f (patch) | |
tree | bef4c8d6ddf731738db0360a82f69e0b105b34ec | |
parent | 8a04358596894ee29bc0c9317c66ab6d91508373 (diff) |
backup the schema for tables we don't need the data from. RT#85959
-rw-r--r-- | FS/FS/Cron/backup.pm | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/FS/FS/Cron/backup.pm b/FS/FS/Cron/backup.pm index 8264ae1..65d7acb 100644 --- a/FS/FS/Cron/backup.pm +++ b/FS/FS/Cron/backup.pm @@ -25,7 +25,11 @@ sub backup { my $ext; if ( driver_name eq 'Pg' ) { - system("pg_dump -Fc -T h_cdr -T h_queue -T h_queue_arg -T sessions $database >/var/tmp/$database.Pg"); + system('pg_dump -Fc '. join(' ', map { "--exclude-table-data $_" } + qw( h_cdr h_queue h_queue_arg sessions ) + ). + " $database >/var/tmp/$database.Pg" + ); $ext = 'Pg'; } elsif ( driver_name eq 'mysql' ) { system("mysqldump $database >/var/tmp/$database.sql"); |