I agree start with psql, I started with MySQL/MariaDB because it’s what I knew best and had used for years with Bacula before. Now I have remote clients that there is no way for me to start over and stuck with it.
I have several million files in MySQL and pruning/accurate some of the lager clients takes several minutes. I run a mysql optimize and rebuild the tables (I use file per-table as in the docs) and my growth has been limited to about 40GB, It’s manageable. But yes start with PSQL, and yes I wish there was a way to migrate without doing a big bscan. > On Jan 10, 2020, at 1:09 PM, 'Chad W Seys' via bareos-users > <[email protected]> wrote: > > Actually, just read that the size of the file won't shrink after > compaction "Please note that the database files are never shrunk by MySQL." > > On 1/10/20 12:05 PM, 'Chad W Seys' via bareos-users wrote: >> The bareos documentation also mentions mysql compaction. Maybe that >> would reduce the size of your DB? >> https://docs.bareos.org/TasksAndConcepts/CatalogMaintenance.html#section-mysqlsupport > > -- > You received this message because you are subscribed to the Google Groups > "bareos-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/bareos-users/155b97c1-04cc-12ab-8f54-529ace85ad6f%40physics.wisc.edu. -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/1E820011-2CAA-48FB-BF68-6B3EE0E8CD21%40mlds-networks.com.
