backup the schema for tables we don't need the data from. RT#85959
authorIvan Kohler <ivan@freeside.biz>
Tue, 10 Aug 2021 18:31:05 +0000 (11:31 -0700)
committerIvan Kohler <ivan@freeside.biz>
Tue, 10 Aug 2021 18:31:05 +0000 (11:31 -0700)
FS/FS/Cron/backup.pm

index 2ffbda0..dd09f57 100644 (file)
@@ -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");