Hello Frederic I have a fork o Webacula with a new visual and some improvements. https://github.com/wanderleihuttel/webacula
You cant take a look in the screens here: https://github.com/wanderleihuttel/webacula/wiki Best regards *Wanderlei Hüttel* http://www.bacula.com.br Em qui, 10 de jan de 2019 às 20:48, Frédéric F. <cipher1...@gmail.com> escreveu: > Hello everyone, > I use Bacula for 3 months and I am happy to use it. > However I have several problems with the GUI Baculum. > > In Baculum, I have problem to restore files with path contains ' > character like "D:\Data\l'information" > I can see in baculum the folder but when I select it, I can't browse > into, the sub folder is empty. > I can restore upper folder but it's not a great job. > Any advice to browse in baculum with folders with special character ? > I have a lot... > > Another problem with Baculum : > Randomly, I have some lag (about 20 minutes) when I select a "group > most recent backup" or one full backup in the list. > My postgresql DB is working at 100% on 1CPU/8 for about 20 minutes. > > I optimize my postgresql DB and with pg_stat_statements, I found the > slow bacula query (sorry for presentation) : > > postgres=# SELECT * > FROM > pg_stat_statements > ORDER BY > total_time DESC; > userid | dbid | queryid | query | calls | total_time | > min_time | max_time | mean_time | stddev_time > | rows | shared_blks_hit | shared_blks_read | shared_blks_dirtied > | shared_blks_written | local_blks_hit | local_blks_read | > local_blks_dirtied | local_blks_written | temp_blks_read | > temp_blks_written | blk_read_time | blk_write_time > > 10 | 16384 | 1980744281 | INSERT INTO PathVisibility (PathId, > JobId) SELECT a.PathId,$1 FROM ( SELECT DISTINCT h.PPathId AS PathId > FROM PathHierarchy AS h JOIN P > athVisibility AS p ON (h.PathId=p.PathId) WHERE p.JobId=$2) AS a LEFT > JOIN (SELECT PathId FROM PathVisibility WHERE JobId=$3) AS b ON > (a.PathId = b.PathId) WHERE b.Path > Id IS NULL | 60 | 1478982.747849 | 0.225819 | > 484839.953712 | 24649.71246415 | 105518.8118646 > 13 | 4074 | 205691266 | 165 | > 62 | 0 | 0 | 0 | > 0 | > 0 | 1011 | 1014 | 0 | 0 > > I am not sure it is a DB problem rather a bacula optimization but what ? > > According to my stats, I have : > - 5.31 TB of data saved, around 13M files > - Bacula DB 5,18 Go > - Fileset : 82 > > OS : CentOS 7.5.1804 > Postgresql : 10.6 > Bacula : 9.2.1-1-el7 > > Postgresql.conf tweaks : > > max_connections = 100 > shared_buffers = 2016MB > maintenance_work_mem = 512MB > effective_cache_size = 6GB > max_worker_processes = 8 > max_parallel_workers_per_gather = 2 > max_parallel_workers = 8 > > > Hardware > HP Proliant server (2017) > CPU Xeon 4/8 cores > Memory : 8 Go > HD in RAID 5 (no SSD) > > Off topic question : is there another web GUI to restore files easily ? > > Thank you for your help > > PS : sorry for my approximate english. > > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users >
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
