--- - hosts: postgresql-server roles: - role: ANXS.postgresql become: yes

--- - hosts: postgresql-server tasks: - block: # workaround, see https://stackoverflow.com/a/56558842 - name: PSQL installation and configuration include_role: name: ANXS.postgresql vars: postgresql_users: - name: abc password: abc become: true

# Basic settings postgresql_version: 17 postgresql_encoding: "UTF-8" postgresql_locale: "en_US.UTF-8" postgresql_ctype: "en_US.UTF-8" postgresql_admin_user: "postgres" postgresql_default_auth_method: "peer" postgresql_cluster_name: main postgresql_cluster_reset: false # List of databases to be created (optional) # Note: for more flexibility with extensions use the postgresql_database_extensions setting. postgresql_databases: - name: foobar owner: baz # optional; specify the owner of the database hstore: yes # flag to install the hstore extension on this database (yes/no) uuid_ossp: yes # flag to install the uuid-ossp extension on this database (yes/no) citext: yes # flag to install the citext extension on this database (yes/no) encoding: "UTF-8" # override global {{ postgresql_encoding }} variable per database state: "present" # optional; one of 'present', 'absent', 'dump', 'restore' lc_collate: "en_GB.UTF-8" # override global {{ postgresql_locale }} variable per database lc_ctype: "en_GB.UTF-8" # override global {{ postgresql_ctype }} variable per database # List of database extensions to be created (optional) postgresql_database_extensions: - db: foobar extensions: - hstore - citext # List of users to be created (optional) postgresql_users: - name: baz pass: pass encrypted: yes # if password should be encrypted, postgresql >= 10 does only accepts encrypted passwords state: "present" # optional; one of 'present', 'absent' # List of schemas to be created (optional) postgresql_database_schemas: - database: foobar # database name schema: acme # schema name state: present - database: foobar # database name schema: acme_baz # schema name owner: baz # owner name state: present # List of user privileges to be applied (optional) postgresql_user_privileges: - name: baz # user name db: foobar # database priv: "ALL" # privilege string format: example: INSERT,UPDATE/table:SELECT/anothertable:ALL role_attr_flags: "CREATEDB" # role attribute flags