Thank you for your answer.

So I will wait for the next release to update :)

About the lag in the Baculum restore wizard, is everyone suffering
this issue ? Because it is very random.

Best regards.

Frédéric.

Le sam. 12 janv. 2019 à 20:38, Marcin Haba <ganius...@gmail.com> a écrit :
>
> 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

Reply via email to