On 10/4/23 06:28, Yateen Shaligram Bhagat (Nokia) wrote:
We don’t need the File Records in backup because :1. Each of our production servers (hundreds of them) being backed up, has number of files in the range of hundred-thousands. 2. With Catalog Files = Yes (default), the database (PostGreSQL) hogs the CPUs on the host, with say 100 concurrent weekly Full backup jobs, putting a lot of stress on the server. 3. Last but not the least, there is hardly a need to precisely locate a single file during restoration. The restore is always in bulk at top dir level. With Catalog Files = No (in pool resource def) , we have already seen a big performance enhancement on the DB server. Bu there is a flip side, Virtual Full backup can no longer be achieved. -Yateen S Bhagat
Hello Yateen,Another thing to know is that you also cannot do "Accurate" mode backups, nor Verify, nor Copy, nor Migration Jobs if you do not have files in the catalog.
Best regards, Bill -- Bill Arlofski w...@protonmail.com
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
