1. What is the nature and description of the request?

Seeking a method to change the DB address after installation in the containerized aap2.5.

Not through the installer and reinstall again. With the current investigation, it seems only gateway and eda can support change the database through edit the setting file.

aap/gateway/etc/settings.py:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'dbname',
        'USER': 'dbuser',
        'HOST': 'dbhos',
        'PORT': '5432',
        'OPTIONS': {
            'options': '-c datestyle=ISO,\ MDY',
            'sslmode': 'verify-full',
            'sslrootcert': '/etc/pki/tls/certs/ca-bundle.crt',
            'sslcert': '/etc/ansible-automation-platform/gateway/postgresql.cert',
            'sslkey': '/etc/ansible-automation-platform/gateway/postgresql.key',
        },
    }
}

aap/eda/etc/settings.yaml


ACTIVATION_DB_HOST: 'dbhost'
DB_HOST: 'dbhost'
PGSSLMODE: 'verify-full'
PGSSLROOTCERT: '/etc/pki/tls/certs/ca-bundle.crt'
PGSSLCERT: '/etc/eda/postgresql.cert'
PGSSLKEY: '/etc/eda/postgresql.key'
 

I can't find any setting file that belongs to the controller and hub can edit the database address after installation.

      2. Why does the customer need this? (List the business requirements here)

First, from the customer's perspective, reinstallation is a high-risk behavior, and they think it is ridiculous. Of course, if any evidence or document can provide this reinstallation is valid, please tell me.

Second, in a DR scene, some nodes are unavailable, reinstallation means some nodes can't be reached. The reinstallation will fail.

For others, database update(renew certificate, password updating..etc) is a common operation.