[Spacewalk-list] Spacewalk 1.2 and postgresql - too many clients already

[Michael Mraka]

Michal Bruncko wrote:
% Hi list
% 
% Please, what is the recommened (or minimum recommened) number of
% running postgresql instances (max_connections parameter in
% postgresql.conf) for spacewalk?
% I am using postgresql db only for spacewalk and I have registered
% approx. 20 clients. For now, I am using only packages distribution
% to clients from repozitories, without errata nor audit or
% monitoring. And have received sometimes (mainly after spacewalk
% machine restart) RHN Traceback messages complains about DB
% (re-)connection.
% Default value of max_connections was 100 and I've increased it to
% 500, but I guess it isnt enough because I have also received same
% connection problems messages from spacewalk in time (tventy-threety
% mails in row). And when I have logged into spacewalk server there
% was all 500 instances of postgresql running. With oracle DB that
% I've using it before potrges I never have same problems (with
% default oracle configuration).

Hi Michal,

for Oracle we set processes to 400 by default which seems to be quite
enough even for very big installations. On the other might be a difference
between PostgreSQL and Oracle driver so e.g. the first one don't close
session automaticaly on some event while the other do so.

If you are able to reproduce the error please file a bugzilla.

Thanks,

--
Michael Mráka
Satellite Engineering, Red Hat