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

Reply via email to