Hi John, turns out we're cheating.
mysql -u bacula -p${BACULAMYSQLPW} -e "DELETE FROM Client WHERE Name='${FDHOSTNAME}';" bacula dbcheck -b -f -y -c /etc/bacula/bacula-dir.conf So we're just deleting the client, and then let bacula get the database back into a consistent state. Depending on your load and requirements that might not be feasible for you, of course. Kind regards, Rolf Halmen On 16.01.2018 17:47, John Naggets wrote: > Hi Rolf, > > So if I understand correctly, there is no "standard" procedure or any > documentation how to properly remove a client once it is not needed > anymore (e.g. when decomissioning a server)? > > If not I would be interested to see your SQL query which you use for > that purpose. > > Indeed I use the "use volume once = true" parameter so that each > volume contains only one single backup from a client. > > Best regards, > J. > > On Mon, Jan 15, 2018 at 4:59 PM, Rolf Halmen > <rolf.hal...@neubert-consulting.de> wrote: >> Hi John, >> >> The database can correlate jobs to volume files. >> I'm not at a workstation right now, but off the top of my head, I'd assume >> joining the jobs, media, and clients tables should let you get to the list >> of volumes that contain backup-data of the specified client. >> >> Do keep in mind that volume files can contain data from multiple jobs, >> unless "use volume once = true". >> >> Kind regards, >> Rolf >> >> On January 15, 2018 2:10:00 PM UTC, John Naggets <hostingnugg...@gmail.com> >> wrote: >>> Hello, >>> >>> It happens that some clients on the network get removed and as such do >>> not need to be backed up anymore. Now I would like to know what is the >>> procedure on the bacula director in order to remove properly and >>> entirely a bacula client? >>> >>> I checked the official documentation but could not find any procedure >>> for that purpose. >>> >>> From my understanding I need to delete the jobs and files associated >>> with them as well as the volumes and finally the physical volumes on >>> the filesystem (backups are done on files on a partition of the backup >>> server). >>> >>> My problem here is that the physical volumes on the filesystem all >>> have the same label except for the number so how would I know which >>> file I can delete? >>> >>> Thank you in advance for your help. >>> >>> Best regards, >>> John >>> >>> ________________________________ >>> >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >>> ________________________________ >>> >>> Bacula-users mailing list >>> Bacula-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/bacula-users >> >> -- >> Sent from my Android device with K-9 Mail. Please excuse my brevity. >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> Bacula-users mailing list >> Bacula-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users >> -- Rolf Michael Halmen Softwareentwickler Neubert Consulting GmbH, IT Consulting & Services Theaterstr. 33 D-90762 Fuerth Tel: +49 (0911) 972799 - 54 Fax: +49 (0911) 972799 - 33 Mail rolf.hal...@neubert-consulting.de Web www.neubert-consulting.de Geschäftsführer Christoph Neubert Registergericht Fürth HRB 10620
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users