description => "Cleanup the database backups",
},
{
- command => "cd $pg_backup_path ; /usr/bin/rm -f $(ls -1 *T22*.sql | log2rotate --skip 7 --fuzz 7 --delete --format='%Y-%m-%dT%H:%M:%S+02:00.sql')",
+ command => "cd $pg_backup_path ; /usr/bin/rm -f $(ls -1 *T22*.sql | log2rotate --skip 7 --fuzz 7 --delete --format='\%Y-\%m-\%dT\%H:\%M:\%S+02:00.sql')",
user => $pg_user,
hour => 3,
minute => 1,
},
]
}
+
+ @profile::monitoring::local_service { "Last postgresql dump in $pg_backup_path is not too old":
+ sudos => {
+ "naemon-postgresql-dumps-$pg_host" => "naemon ALL=($pg_user) NOPASSWD: /usr/bin/find $pg_backup_path -mindepth 1 -maxdepth 1 -printf %T@?n",
+ },
+ local => {
+ check_command => "check_last_file_date!$pg_backup_path!7!$pg_user",
+ }
+ }
}