How to configure custom hiera for foreman-installer to keep custom Postgres tuning

Solution Verified - Updated -

Issue

I am working on a custom hiera to ensure performance tuning changes are not overwritten when Satellite 6 is updated/upgraded. I've been able to determine the proper settings for pulp and foreman, but I'm having difficulty determining the proper entries to use for tuning PostgreSQL.

If I'm reading the config_entry.pp manifest, I would need to add the following to my custom hiera:

postgresql::server::config_entry:PARAMETER: VALUE

However, many of the parameters I want to change appear not to be supported by the module. It looks like I could set:

postgresql::server::config_entry:max_connections: 500
postgresql::server::config_entry:shared_buffers: 7680MB
postgresql::server::config_entry:wal_buffers: 16MB

However, it doesn't appear I can change the following parameters:

maintenance_work_mem
checkpoint_completion_target
checkpoint_segments
work_mem

So, I have a couple of questions:

1) Is the format I have listed correct for the custom hiera for the supported parameters?
2) For those parameters not supported by the module, does the installer overwrite the entire postgresql.conf file, or edit the file to modify the parameters to the values specified -- in other words, can I customize the file for parameters not supported by the module and have those values remain unchanged after an upgrade?

Environment

Red Hat Satellite 6.3

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content