Re: postgres load at restore

On 8/29/24 14:32, Marcin Haba wrote:
> On Thu, 29 Aug 2024 at 20:14, Phil Stracchino <[email protected] 
> <mailto:[email protected]>> wrote:
> 
>     NIGHTLY
>              Run all scheduled client backup jobs
>              Incremental rebuild bvfs cache
>              Run catalog backup
> 
>     WEEKLY
>              Clear bvfs cache
>              Run dbcheck
>              Full rebuild bvfs cache
> 
> 
> Yes, I see your idea. This full rebuild will cost creating all cache 
> from scratch. For many jobs and paths it will take lots of resources.

Well, I just tested my revised dbcheck script with inline bvfs cache 
clear and rebuild, and it worked fine, runs for about two hours.  My 
bvfs update job to run after all backups needs a little work though. 
The job definition looks like this:

Job {
   Name = "BVFS Update"
   Type = Admin
   Enabled = Yes
   Pool = Scratch
   Storage = epsilon3-file
   FileSet = Dummy
   Client = epsilon3
   Level = Full
   Runscript {
     Runs When = Before
     Runs On Client = no
     Console = ".bvfs_update"
   }
   Messages = Daemon
   Priority = 18
   Rerun Failed Levels = no
   Allow Duplicate Jobs = no
   Cancel Queued Duplicates = yes
   Schedule = "BVFS Update"
}


Its schedule looks like this:

# BVFS maintenance schedule
Schedule {
   Name = "BVFS Update"
   Run = Full mon-sun at 05:30
}


But when run manually from BAT, BAT won't let me specify a level, runs 
.bvfs_update with an empty level, then errors out because "" is not a 
valid level.




-- 
   Phil Stracchino
   Fenian House Publishing
   [email protected]
   [email protected]
   Landline: +1.603.293.8485
   Mobile:   +1.603.998.6958



_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users