diff options
Diffstat (limited to 'roles/ttrss/tasks/database.yml')
-rw-r--r-- | roles/ttrss/tasks/database.yml | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/roles/ttrss/tasks/database.yml b/roles/ttrss/tasks/database.yml new file mode 100644 index 0000000..ca20eeb --- /dev/null +++ b/roles/ttrss/tasks/database.yml @@ -0,0 +1,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') |