Configure custom PostgreSQL settings

The postgres_extra_settings variable allows you to pass a list of custom name: value pairs directly to the PostgreSQL configuration file (/var/lib/pgsql/data/postgresql.conf) within the database pod.

Before you begin

  • You have installed the Ansible Automation Platform Operator.

About this task

Procedure

  1. Log in to Red Hat OpenShift Container Platform.
  2. Go to Operators Installed Operators.
  3. Select your Ansible Automation Platform Operator deployment.
  4. Select All Instances and go to your Ansible Automation Platform instance.
  5. Click the ⋮ icon and then select Edit Ansible Automation Platform.
  6. In the YAML view, locate the spec: section
  7. Add the database section and the required settings under spec:. The following example configures SSL ciphers and the maximum connections: 
    spec:
  database:
    postgres_extra_settings:
      - name: max_connections
        value: '1000'
  8. Click Save.

Results

Inspect the PostgreSQL pod logs to verify the new settings.

Alternatively, you can run the following command to check the settings. Replace <aap postgres pod> with the name of your PostgreSQL pod.

$ oc exec -it <aap postgres pod> -- psql -d gateway -c "SHOW max_connections;"