Ansible Role for PostgreSQL Server 14

This role is designed to help you install and set up PostgreSQL Server 14 on Debian (buster/bullseye).

Requirements

You will need Ansible version 2.9 or higher to use this role.

Role Variables

Here are the variables you can use with this role, along with a short description for each:

---
pgsql_root_password: Aver@gEStr0ngPaSSw0rd  # The root password for PostgreSQL
pgsql_data_dir: /path/to/psql/data          # The directory for PostgreSQL data files
pgsql_listen_addresses: 10.0.0.1             # The IP address PostgreSQL listens on
pgsql_listen_port: 7654                      # The port PostgreSQL listens on
pgsql_auth_method: md5                       # The authentication method (like md5 or scram-sha-256)
pgsql_map_name: rootmap                      # The mapping name for users
pgsql_map_sysuser: root                      # The system username
pgsql_map_pguser: postgres                   # The PostgreSQL username

All the above variables, except for 'pgsql_root_password', can be changed. Here are the default values for the optional ones:

---
pgsql_data_dir: /var/lib/postgresql/14/main  # Default data directory
pgsql_listen_addresses: localhost            # Default listen address
pgsql_listen_port: 5432                      # Default listen port
pgsql_auth_method: scram-sha-256             # Default authentication method
pgsql_map_name: rootmap                      # Default mapping name
pgsql_map_sysuser: root                      # Default system username
pgsql_map_pguser: postgres                   # Default PostgreSQL username

Dependencies

There are no dependencies for this role.

Example Playbook

Here’s an example of how to use this role in a playbook. You can pass in variables as needed:

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

License

This role is licensed under the MIT License.

Author Information

This role was created by Artem Kasianchuk.