|
It is a *very* bad idea to do any direct operations on the SQL
database, particularly deleting records. This is NOT a good
solution.
If you need to delete a client, you should do it through some
bconsole command (other than the sql command) so that all the
tables/records that are connected to a client are also deleted.
Best regards,
Kern
On 17.01.2018 10:51, Rolf Halmen wrote:
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
------------------------------------------------------------------------------
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
|
------------------------------------------------------------------------------
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
