Bug #37335
open
PostgreSQL parameters have no effect
Description
RHEL9 + Foreman 3.10 + Katello 4.12
Adjusting settings via postgresql::server::config_entries in /etc/foreman-installer/custom-hiera.yaml or parameter --tuning medium creates these settings in /etc/postgresql.conf instead of /var/lib/pgsql/data/postgresql.conf.
The parameter postgresql::server::postgresql_conf_path does not change anything.
The settings have no effect (during and after the installation) as one can see with:
psql -c 'show max_connections' # as user postgres -> 100
As a result the installation fails with 8 cores since there are too few connections possible.
With 6 cores it works but the performance for further tasks is really bad and the settings must manually be fixed.
foreman-installer \
--scenario katello \
--no-enable-puppet \
--certs-server-cert ... \
--certs-server-key ... \
--certs-server-ca-cert ... \
--foreman-initial-admin-email ... \
--foreman-email-reply-address ... \
--foreman-initial-location ... \
--foreman-initial-organization ... \
--skip-puppet-version-check \
-v # or with additional --tuning medium
Updated by Michael Arlt 10 months ago
reproducible with Foreman 3.11.0 nightly:
$ rpm -qa|grep -i foreman
foreman-release-3.11.0-0.1.develop.el9.noarch
rubygem-foreman_maintain-1.6.4-1.el9.noarch
foreman-selinux-3.11.0-0.1.develop.20240226091422gita8664f9.el9.noarch
foreman-installer-3.11.0-0.1.develop.20240418031237gitd83807b.el9.noarch
foreman-installer-katello-3.11.0-0.1.develop.20240418031237gitd83807b.el9.noarch
rubygem-hammer_cli_foreman-3.11.0-0.1.pre.develop.20240326195053git0debe18.el9.noarch
rubygem-hammer_cli_foreman_tasks-0.0.21-1.fm3_11.el9.noarch
foreman-3.11.0-0.4.develop.20240418155255git42e7178.el9.noarch
rubygem-foreman-tasks-9.1.1-1.fm3_11.el9.noarch
rubygem-foreman_remote_execution-13.0.0-1.fm3_11.el9.noarch
foreman-postgresql-3.11.0-0.4.develop.20240418155255git42e7178.el9.noarch
foreman-service-3.11.0-0.4.develop.20240418155255git42e7178.el9.noarch
foreman-dynflow-sidekiq-3.11.0-0.4.develop.20240418155255git42e7178.el9.noarch
foreman-redis-3.11.0-0.4.develop.20240418155255git42e7178.el9.noarch
foreman-proxy-3.11.0-0.1.develop.20240402162104gite8fe59f.el9.noarch
foreman-cli-3.11.0-0.4.develop.20240418155255git42e7178.el9.noarch
rubygem-hammer_cli_foreman_remote_execution-0.3.0-1.el9.noarch
Updated by Ewoud Kohl van Wijngaarden 9 months ago
Have you previously had this working on EL8 or is this EL9 specific?
Updated by Michael Arlt 8 months ago
Ewoud Kohl van Wijngaarden wrote in #note-4:
Have you previously had this working on EL8 or is this EL9 specific?
I am sorry, I used this the first time on EL9 - I don't know.
We don't have EL8 to test it.