# Basic settingspostgresql_version: 12postgresql_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_service_enabled: false # should the service be enabled, default is truepostgresql_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: foobarowner: baz # optional; specify the owner of the databasehstore: 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 databaselc_collate: "en_GB.UTF-8"# override global{{postgresql_locale }} variable per databaselc_ctype: "en_GB.UTF-8"# override global{{postgresql_ctype }} variable per database# List of database extensions to be created (optional)postgresql_database_extensions: - db: foobarextensions: - hstore - citext# List of users to be created (optional)postgresql_users: - name: bazpass: passencrypted: yes # if password should be encrypted, postgresql >= 10 does only accepts encrypted passwords# List of schemas to be created (optional)postgresql_database_schemas: - database: foobar # database nameschema: acme # schema namestate: present - database: foobar # database nameschema: acme_baz # schema nameowner: baz # owner namestate: present# List of user privileges to be applied (optional)postgresql_user_privileges: - name: baz # user namedb: foobar # databasepriv: "ALL"# privilege string format: example: INSERT,UPDATE/table:SELECT/anothertable:ALLrole_attr_flags: "CREATEDB"# role attribute flags