... | ... | @@ -682,6 +682,16 @@ This would list 10 files out of the backup job 251481: |
|
|
ORDER BY starttime DESC
|
|
|
LIMIT 10;
|
|
|
|
|
|
This will list the 10 oldest files backed up on host `submit-01.torproject.org`:
|
|
|
|
|
|
SELECT jobid, job.name,type,level,starttime, path.path || filename.name AS path FROM path
|
|
|
JOIN file USING (pathid)
|
|
|
JOIN filename USING (filenameid)
|
|
|
JOIN job USING (jobid)
|
|
|
WHERE job.name='submit-01.torproject.org'
|
|
|
ORDER BY starttime ASC
|
|
|
LIMIT 10;
|
|
|
|
|
|
## Excluding files from backups
|
|
|
|
|
|
Bacula has a list of files excluded from backups, mostly things like
|
... | ... | |