aboutsummaryrefslogtreecommitdiffstats
path: root/roles/ttrss/tasks/database.yml
blob: ca20eeb1ee1ee0d53d8c76a9ad5a7479b56a6efa (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
- name: create database
  postgresql_db:
    name: '{{ ttrss_db_name }}'
    state: present
  delegate_to: "{{ postgresql_inventory_host }}"
  become: yes
  become_user: postgres

- name: create database user
  postgresql_user:
    name: '{{ ttrss_user }}'
    db: '{{ ttrss_db_name }}'
    priv: ALL
    state: present
  delegate_to: "{{ postgresql_inventory_host }}"
  become: yes
  become_user: postgres

- name: update database schema
  command: php {{ ttrss_home }}/update.php --update-schema=force-yes
  become: yes
  become_user: apache
  environment:
    GSS_USE_PROXY: 'yes'
  register: ttrss_update_schema
  changed_when: ttrss_update_schema.stdout is not search('Database schema is already at latest version')