... | ... | @@ -661,6 +661,27 @@ full backup instead, which, in this case, did work: |
|
|
81599
|
|
|
root@bacula-director-01:~#
|
|
|
|
|
|
This query will list the jobs having the given file:
|
|
|
|
|
|
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 path.path='/var/log/gitlab/gitlab-rails/'
|
|
|
AND filename.name LIKE 'production_json.log%'
|
|
|
ORDER BY starttime DESC
|
|
|
LIMIT 10;
|
|
|
|
|
|
This would list 10 files out of the backup job 251481:
|
|
|
|
|
|
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 jobid=251481
|
|
|
ORDER BY starttime DESC
|
|
|
LIMIT 10;
|
|
|
|
|
|
## Excluding files from backups
|
|
|
|
|
|
Bacula has a list of files excluded from backups, mostly things like
|
... | ... | |