Bug #37335
Updated by Michael Arlt 10 months ago
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:
<pre><code class="shell">
psql -c 'show max_connections' # as user postgres -> 100
</code></pre>
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.
<pre><code class="shell">
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
</code></pre>