1 files changed, 34 insertions, 0 deletions
diff --git a/ansible/roles/postgres/tasks/main.yml b/ansible/roles/postgres/tasks/main.yml
new file mode 100644
index 0000000..9551c4e
--- /dev/null
+++ b/ansible/roles/postgres/tasks/main.yml
@@ -0,0 +1,34 @@
+- name: Install postgres packages
+  apt:
+    name:
+      - python3-psycopg2
+      - postgresql-{{ postgresql_version }}
+      - postgresql-contrib-{{ postgresql_version }}
+      - libpq-dev
+    state: present
+  tags:
+    - role::postgres
+
+- name: Check postgres is started and enabled on boot
+  service:
+    name: '{{ postgresql_daemon }}'
+    state: started
+    enabled: true
+  tags:
+    - role::postgres
+
+- name: Add postgres users
+  community.postgresql.postgresql_user: "{{ item }}"
+  with_items: "{{ postgresql_users }}"
+  become: true
+  become_user: "{{ postgresql_user }}"
+  tags:
+    - role::postgres
+
+- name: Add postgres databases
+  community.postgresql.postgresql_db: "{{ item }}"
+  with_items: "{{ postgresql_databases }}"
+  become: true
+  become_user: "{{ postgresql_user }}"
+  tags:
+    - role::postgres