Sha256: 01d6b86dd5aa2ab2da1f44f79605fe5291e064d1ce7f426f59b70daac202900c

Contents?: true

Size: 906 Bytes

Versions: 40

Compression:

Stored size: 906 Bytes

Contents

---
  - set_fact: postgresql_installed="true"

  - name: Create postgresql user
    postgresql_user:
      name: "{{database_user}}"
      password: "{{database_password}}"
      state: present
    become: true
    become_user: postgres

  - name: Create postgresql database
    postgresql_db:
      name: "{{database_name}}"
      owner: "{{database_user}}"
      template: template1
      state: present
    become: true
    become_user: postgres

  - name: Grant all privileges on database to user
    postgresql_privs:
      database: "{{database_name}}"
      privs: ALL
      roles: "{{database_user}}"
      state: present
      type: database
    become: true
    become_user: postgres

  - name: "Enable postgres hstore"
    become: true
    become_user: postgres
    postgresql_ext:
      db: "{{database_name}}"
      name: hstore
      state: present

  - include: backups.yml
    become: true

Version data entries

40 entries across 40 versions & 1 rubygems

Version Path
subspace-2.2.3 ansible/roles/postgresql/tasks/main.yml
subspace-2.2.2 ansible/roles/postgresql/tasks/main.yml
subspace-2.2.1 ansible/roles/postgresql/tasks/main.yml
subspace-2.2.0 ansible/roles/postgresql/tasks/main.yml
subspace-2.1.2 ansible/roles/postgresql/tasks/main.yml
subspace-2.1.1 ansible/roles/postgresql/tasks/main.yml
subspace-2.1.0 ansible/roles/postgresql/tasks/main.yml
subspace-2.0.4 ansible/roles/postgresql/tasks/main.yml
subspace-2.0.3 ansible/roles/postgresql/tasks/main.yml
subspace-2.0.2 ansible/roles/postgresql/tasks/main.yml
subspace-2.0.1 ansible/roles/postgresql/tasks/main.yml
subspace-2.0.0 ansible/roles/postgresql/tasks/main.yml
subspace-1.0.8 ansible/roles/postgresql/tasks/main.yml
subspace-1.0.7 ansible/roles/postgresql/tasks/main.yml
subspace-1.0.6 ansible/roles/postgresql/tasks/main.yml
subspace-1.0.5 ansible/roles/postgresql/tasks/main.yml
subspace-1.0.4 ansible/roles/postgresql/tasks/main.yml
subspace-1.0.3 ansible/roles/postgresql/tasks/main.yml
subspace-1.0.2 ansible/roles/postgresql/tasks/main.yml
subspace-1.0.1 ansible/roles/postgresql/tasks/main.yml