cloudera.exe.postgresql_server role – Install PostgreSQL server for Cloudera Manager

Note

This role is part of the cloudera.exe collection (version 3.0.0).

It is not included in ansible-core. To check whether it is installed, run ansible-galaxy collection list.

To install it use: ansible-galaxy collection install cloudera.exe..

To use it in a playbook, specify: cloudera.exe.postgresql_server.

Entry point main – Install PostgreSQL server for Cloudera Manager

New in cloudera.exe 3.0.0

Synopsis

  • Install and configure PostgreSQL server, including required users, for Cloudera Manager.

  • Will install psycopg2 (or psycopg3).

  • Optionally, will enable TLS.

  • Optionally, will create a database superuser.

Parameters

Parameter

Comments

create_database_admin_user

boolean

Flag to specify if a database superuser should be created

Choices:

  • false ← (default)

  • true

database_admin_password

string

Password for database superuser account

database_admin_user

string

Username for database superuser account

postgresql_access_entries

list / elements=dictionary

List of host-based authentication (HBA) entries for PostgreSQL server, i.e. pg_hba.conf file.

address

string

Networking scope.

auth_method

string / required

Authentication method.

database

string / required

Database target.

type

string / required

Authentication scope (type).

user

string / required

User or user type.

postgresql_config_options

list / elements=dictionary

List of global configuration entries for PostgreSQL server, i.e. postgres.conf file.

option

string / required

Name of the parameter.

value

string / required

Value of the parameter.

postgresql_packages

list / elements=string

List of packages for the PostgreSQL installation.

If not defined, defaults are specified by OS distribution.

postgresql_repo_enabled

boolean

Flag enabling the setup and teardown of the PostgreSQL repository.

If postgresql_repo_enable=no, then any existing repositories will be employed.

Choices:

  • false

  • true ← (default)

postgresql_tls_ca_path

path

Path to the TLS certificate authority (CA) file.

If not specified, the PostgreSQL server will employ its default, typically None, i.e. empty.

postgresql_tls_cert_path

path

Path to the TLS certificate file.

If not specified, the PostgreSQL server will employ its default, typically $PGDATA/server.crt.

postgresql_tls_enabled

boolean

Flag enabling TLS connections.

Choices:

  • false ← (default)

  • true

postgresql_tls_key_path

path

Path to the TLS private key file.

If not specified, the PostgreSQL server will employ its default, typically $PGDATA/server.key.

postgresql_version

string

PostgreSQL version to install.

Default: 14

Authors

  • Cloudera Labs