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 11 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 10 months ago
Have you previously had this working on EL8 or is this EL9 specific?
Updated by Michael Arlt 10 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.