|
Hello, I recently took a look at my catalog a bit more in detail when an
upgrade of my backup server from 14.04 to 16.04 failed (I have 6
systems where the upgrade totally failed and left me with a broken
system), and so I reloaded the Bacula catalog from scratch and in
doing so I realized that there were lots and lots of old records
in it from jobs that I had run several years ago. This happens
when you create a job or a client, then stop using that job or
client (or even remove the client) so that no more jobs for that
client run. What is important is that Bacula prunes only when a
job runs unless you do it manually, and if jobs never run, the
retention periods never apply and you end up with lots and lots of
unused (orphaned) records in the catalog. The only way to clean
it up is to see what jobs exist in the database and prune/purge
those which are no longer used -- this is done manual with
bconsole. The same happens if you have lots and lots of temporary files
that get backed up. There are mail programs that create a
temporary file for each email, then delete it a day or two later.
If these files are backed up even once, they will create lots of
name entries in the database. This can be cleaned up by using
dbcheck. Finally, if you can afford a bit of downtime on your database, first back it up, then delete it and recreate it with the backup. This creates a database that is nicely compacted. If you regularly run vacuums this is probably not necessary, but in extreme cases such as after deleting hundreds of old backup jobs or clients, it can be a quick way to compact the database. Note also, your retention periods are quite long so if you have
lots of jobs (more than 100) that run every night, you will need a
big database. Best regards, Kern On 03/16/2017 03:17 PM, James
Chamberlain wrote:
On Mar 16, 2017, at 3:29 AM, Mikhail Krasnobaev <mi...@ya.ru> wrote: |
------------------------------------------------------------------------------ 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
