cloudera.exe.pgadmin role – Install pgAdmin

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.pgadmin.

Entry point main – Install pgAdmin

New in cloudera.exe 3.0.0

Synopsis

  • Install pgAdmin and configure access to a list of specified databases.

  • pgAdmin is run as a container with systemd service file is used to control container stop and start.

Parameters

Parameter

Comments

database_admin_password

string / required

Password for database superuser account

database_admin_user

string / required

Username for database superuser account

database_host

string / required

The hostname or IP address of the database server.

database_port

integer

The port for connecting to the database server.

Default: 5432

pgadmin_db_servers

list / elements=dictionary

List of database connections to pre-load into pgAdmin at first launch

Default: [{"Group": "Servers", "Host": "{{ database_host }}", "MaintenanceDB": "postgres", "Name": "CE Postgres", "PassFile": "/pgpass", "Port": "{{ database_port }}", "SSLMode": "prefer", "Username": "{{ database_admin_user }}"}]

pgadmin_default_email

string

Email account for default user to access the pgAdmin web ui.

Default: "pgadmin@cloudera-labs.com"

pgadmin_default_password

string

Password for default user to access the pgAdmin web ui.

Default: "pgadmin"

pgadmin_docker_exe

string

Directory of docker executable.

Default: "/usr/bin/docker"

pgadmin_pgpass

list / elements=string

Contents of pgpass file with credentials for databases accessed from pgAdmin

Default: ["{{ database_host }}:{{ database_port }}:*:{{ database_admin_user }}:{{ database_admin_password }}"]

pgadmin_port

integer

Port where pgAdmin web ui service will be listening.

Default: 5050

Authors

  • Jim Enright