postgresql/client/pushkin.yml

classes:
  - system.postgresql.client
parameters:
  _param:
    pushkin_db_host: ${_param:haproxy_postgresql_bind_host}
    pushkin_db_user: pushkin
    pushkin_db_user_password: pushkin
  postgresql:
    client:
      server:
        server01:
          database:
            pushkin:
              enabled: true
              encoding: 'UTF8'
              locale: 'en_US'
              users:
              - name: ${_param:pushkin_db_user}
                password: ${_param:pushkin_db_user_password}
                host: ${_param:pushkin_db_host}
                createdb: true
                rights: all privileges
              extension:
                hstore:
                  enabled: true