Contents

---
  - name: Create postgresql user
    postgresql_user:
      name: "{{database_user}}"
      password: "{{database_password}}"
      state: present
    sudo: yes
    sudo_user: postgres

  - name: Create postgresql database
    postgresql_db:
      name: "{{database_name}}"
      owner: "{{database_user}}"
      template: template1
      state: present
    sudo: yes
    sudo_user: postgres

  - name: Grant all privileges on database to user
    postgresql_privs:
      database: "{{database_name}}"
      privs: ALL
      roles: "{{database_user}}"
      state: present
      type: database
    sudo: yes
    sudo_user: postgres

  - name: "Enable postgres hstore"
    sudo: yes
    sudo_user: postgres
    postgresql_ext:
      db: "{{database_name}}"
      name: hstore
      state: present

  - include: backups.yml

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
subspace-0.1.3	ansible/roles/postgresql/tasks/main.yml
subspace-0.1.2	ansible/roles/postgresql/tasks/main.yml
subspace-0.1.1	ansible/roles/postgresql/tasks/main.yml