Re: [Bacula-users] dbcheck, postgres, OOM...
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-users
Re: [Bacula-users] dbcheck, postgres, OOM...
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, no bother to force tune it. best regards -- Radosław Korzeniewski rados...@korzeniewski.net ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] dbcheck, postgres, OOM...
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@lists.sourceforge.net> wrote: > 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 abort the query. > > > > > > How can i do? Thanks. > > > > I would recommend to tune the database server correctly, PostgreSQL is > smart > enough to use the resources that are allocated for any kind of query. When > running "out of memory", it will for example use the disk. > > Maybe the disk is not correctly sized for your database? Maybe the > Postgresql > configuration is not adequate? (the default work_mem was about 64k few > versions > ago), etc... > > Hope it helps! > > Best Regards, > Eric > > > ___ > 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
Re: [Bacula-users] dbcheck, postgres, OOM...
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 'Mixed type'? ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] dbcheck, postgres, OOM...
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.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] dbcheck, postgres, OOM...
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 abort the query. How can i do? Thanks. I would recommend to tune the database server correctly, PostgreSQL is smart enough to use the resources that are allocated for any kind of query. When running "out of memory", it will for example use the disk. Maybe the disk is not correctly sized for your database? Maybe the Postgresql configuration is not adequate? (the default work_mem was about 64k few versions ago), etc... Hope it helps! Best Regards, Eric ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] dbcheck, postgres, OOM...
> 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 certainly would not want to have the same kind of democracy as they have in Iraq (President Vladimir Putin, responding to U.S. President George W. Bush's suggestion that Russia should be more democratic, taken from NewsWeek) ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] dbcheck, postgres, OOM...
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 without a trailing slash Found 1 bad Path records. Checking for Filenames with a trailing slash Found 0 bad Filename records. Checking for duplicate Filename entries. Found 0 duplicate Filename records. Checking for duplicate Path entries. Found 0 duplicate Path records. Checking for orphaned JobMedia entries. Checking for orphaned File entries. This may take some time! Checking for orphaned Path entries. This may take some time! WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. Query failed: SELECT DISTINCT Path.PathId,File.PathId FROM Path LEFT OUTER JOIN File ON (Path.PathId=File.PathId) WHERE File.PathId IS NULL LIMIT 30: ERR=server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. I've tried to lieave more RAM to the VM that run the direcod (and the DB), first 8, the 16 now i try with 32GB, but... Thanks. -- Vedi, è che in gastronomia ci sono quello che mangia e quello che cucina. Nella nostra politica, quello che cucina, manca??? (Emanuele Pucciarelli) ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users