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

Reply via email to