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