Hello Frédéric, Thanks for your feedback about using the Baculum.
The apostrophe problem is a bug that will be fixed in next release. Thanks for reporting it. To the lag when you are going through the restore wizard it is caused by Bvfs cache that has to be built before showing restore browser content. The Baculum uses the Bvfs Bacula feature in restore wizard. I understand that for many files and paths this proces can take a while but I don't know if there is possible to optimize something here. Best regards. Marcin Haba (gani) On Fri, 11 Jan 2019 at 16:08, Frédéric F. <cipher1...@gmail.com> wrote: > > 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 -- "Greater love hath no man than this, that a man lay down his life for his friends." Jesus Christ "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users