Re: [Bacula-users] dbcheck, postgres, OOM...

2023-03-02 Thread Marco Gaiarin
Mandi! Pedro Oliveira In chel di` si favelave... > Yes, Normally I choose, Data Warehouse. Impressive! Probem solved! Thanks!!! ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-us

Re: [Bacula-users] dbcheck, postgres, OOM...

2023-02-28 Thread Radosław Korzeniewski
Hi, wt., 28 lut 2023 o 12:05 Chris Wilkinson napisał(a): > I run Bacula+Postgres on a raspberry pi, 4 core, 8GB and have never tuned > the database, just the default settings. The dbcheck works fine. > > I'm wondering now whether i should tune it or leave well alone? > If it suits your needs, n

Re: [Bacula-users] dbcheck, postgres, OOM...

2023-02-28 Thread Chris Wilkinson
I run Bacula+Postgres on a raspberry pi, 4 core, 8GB and have never tuned the database, just the default settings. The dbcheck works fine. I'm wondering now whether i should tune it or leave well alone? -Chris Wilkinson On Tue, 28 Feb 2023, 08:04 Eric Bollengier via Bacula-users, < bacula-users@

Re: [Bacula-users] dbcheck, postgres, OOM...

2023-02-28 Thread Pedro Oliveira
Hi Marco, Yes, Normally I choose, Data Warehouse. Best Regards Pedro Às 10:18 de 28/02/23, Marco Gaiarin escreveu: Mandi! Pedro Oliveira In chel di` si favelave... Tune Postgresql with pgtune Do you mean: https://pgtune.leopard.in.ua/ ?! Bacula is more a 'Web application' or a

Re: [Bacula-users] dbcheck, postgres, OOM...

2023-02-28 Thread Marco Gaiarin
Mandi! Pedro Oliveira In chel di` si favelave... > Tune Postgresql with pgtune Do you mean: https://pgtune.leopard.in.ua/ ?! Bacula is more a 'Web application' or a 'Mixed type'? ___ Bacula-users mailing list Bacula-users@lists.sourceforg

Re: [Bacula-users] dbcheck, postgres, OOM...

2023-02-28 Thread Eric Bollengier via Bacula-users
Hello Marco, On 2/27/23 16:50, Marco Gaiarin wrote: I've tried to lieave more RAM to the VM that run the director (and the DB), first 8, the 16 now i try with 32GB, but... For the archive, with 32GB of RAM pstgres does not crash, but still cath an out_of_memory condition (correctly) and abor

Re: [Bacula-users] dbcheck, postgres, OOM...

2023-02-27 Thread Marco Gaiarin
> I've tried to lieave more RAM to the VM that run the director (and the DB), > first 8, the 16 now i try with 32GB, but... For the archive, with 32GB of RAM pstgres does not crash, but still cath an out_of_memory condition (correctly) and abort the query. How can i do? Thanks. -- We certa

[Bacula-users] dbcheck, postgres, OOM...

2023-02-24 Thread Marco Gaiarin
In a mid-sized bacula installation (debian buster based, so bacula 9.4) i've renamed some clients and pool, so i wanted to do a 'dbcheck' to cleanup the database. But postgres get killed by OOM: root@lnfbacula:~# dbcheck -b -d 10 /var/lib/bacula bacula bacula password Checking for Paths witho