Database variables

postgresql_admin_database

Database name used for connections to the PostgreSQL database server.

Optional

postgres

postgresql_admin_password

Password for the PostgreSQL admin user. When used, the installation program creates each component's database and credentials.

Required if using postgresql_admin_username.

postgresql_admin_username

Username for the PostgreSQL admin user. When used, the installation program creates each component's database and credentials.

Optional

postgres

postgresql_disable_tls

Controls whether SSL/TLS is enabled or disabled for the PostgreSQL database.

Optional

false

postgresql_effective_cache_size

Memory allocation available (in MB) for caching data.

Optional

postgresql_extra_settings

Defines additional settings for use by PostgreSQL.

Example usage:

postgresql_extra_settings=[{"setting": "ssl_ciphers", "value": "HIGH:!aNULL:!MD5"}]

Optional

postgresql_firewall_zone

The firewall zone where PostgreSQL related firewall rules are applied. This controls which networks can access PostgreSQL based on the zone's trust level.

Optional

public

postgresql_keep_databases

Controls whether or not to keep databases during uninstall. This variable applies to databases managed by the installation program only, and not external (customer-managed) databases. Set to true to keep databases during uninstall.

Optional

false

postgresql_log_destination

Destination for server log output.

Optional

/dev/stderr

postgresql_max_connections

Maximum number of concurrent connections to the database if you are using an installer-managed database.

Optional

1024

postgresql_password_encryption

The algorithm for encrypting passwords.

Optional

scram-sha-256

postgresql_port

Port number that the PostgreSQL server listens on. This variable configures the server-side listening port in postgresql.conf. To configure the port that a specific component uses to connect to PostgreSQL, use the component-specific port variable, for example, controller_pg_port for automation controller.

Optional

5432

postgresql_shared_buffers

Memory allocation (in MB) for shared memory buffers.

Optional

postgresql_tls_cert

Path to the PostgreSQL SSL/TLS certificate file.

Optional

postgresql_tls_key

Path to the PostgreSQL SSL/TLS key file.

Optional

postgresql_tls_remote

Denote whether the PostgreSQL provided certificate files are local to the installation program (false) or on the remote component server (true).

Optional

false

postgresql_use_archive_compression

Controls whether archive compression is enabled or disabled for PostgreSQL. You can control this functionality globally by using use_archive_compression.

Optional

true