Hello, Thank you for your answer, I will try your fork next week. I use CentOS for intructions.
If anyone have an idea about my issues, I am interested. Le ven. 11 janv. 2019 à 12:27, Wanderlei Huttel <wanderleihut...@gmail.com> a écrit : > > Are you using CentOS or Debian? > > Best regards > > Wanderlei Hüttel > http://www.bacula.com.br > > > Em sex, 11 de jan de 2019 às 09:24, Chris Wilkinson <winstonia...@gmail.com> > escreveu: >> >> My Portuguese is not so good >> >> Regards >> Chris Wilkinson >> >> On Fri, 11 Jan 2019, 11:22 am Wanderlei Huttel <wanderleihut...@gmail.com >> wrote: >>> >>> Hello Chris >>> >>> Yes there is, but the instructions are in Portuguese. >>> https://github.com/wanderleihuttel/bacula-utils/tree/master/tutorial >>> >>> >>> Best regards >>> >>> Wanderlei Hüttel >>> http://www.bacula.com.br >>> >>> >>> Em sex, 11 de jan de 2019 às 09:16, Chris Wilkinson >>> <winstonia...@gmail.com> escreveu: >>>> >>>> Very interesting. Is there a link for the installation instructions? The >>>> docs folder appears to be old. >>>> >>>> Regards >>>> Chris Wilkinson >>>> >>>> On Fri, 11 Jan 2019, 9:34 a.m. Wanderlei Huttel <wanderleihut...@gmail.com >>>> wrote: >>>>> >>>>> 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 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
