Ansible Role for PostgreSQL Server 14

This role helps to install and configure PostgreSQL Server 14 to Debian (buster/bullseye).

Requirements

This role requires Ansible 2.9 or higher.

Role Variables

The variables that can be passed to this role and a brief description about them are as follows:

---
pgsql_root_password: Aver@gEStr0ngPaSSw0rd
pgsql_data_dir: /path/to/psql/data
pgsql_listen_addresses: 10.0.0.1
pgsql_listen_port: 7654
pgsql_auth_method: md5
pgsql_map_name: rootmap
pgsql_map_sysuser: root
pgsql_map_pguser: postgres

All of the above variables except the 'pgsql_root_password' are optional. Default values for optional variables:

---
pgsql_data_dir: /var/lib/postgresql/14/main
pgsql_listen_addresses: localhost
pgsql_listen_port: 5432
pgsql_auth_method: scram-sha-256
pgsql_map_name: rootmap
pgsql_map_sysuser: root
pgsql_map_pguser: postgres

Dependencies

None.

Example Playbook

Including an example of how to use your role (for instance, with variables passed in as parameters) is always nice for users too:

- hosts: servers
  roles:
    - { role: role-postgresql, tags: postgresql }

License

MIT

Author Information

BCE NFRANCE

Source This role was created by Artem Kasianchuk. https://github.com/leadlineit/ansible-role-postgresql