roles/postgresql: Add role

1 files changed, 32 insertions, 0 deletions

diff --git a/roles/postgresql/main.yml b/roles/postgresql/main.yml
new file mode 100644
index 0000000..2ab2498
--- /dev/null
+++ b/roles/postgresql/main.yml
@@ -0,0 +1,32 @@
+---
+# Target: alpine3.11
+- name: Install PostgreSQL server
+  hosts: postgresql
+  vars:
+    config_path: /etc/postgresql
+  tasks:
+  - name: Installing the application
+    apk:
+      state: present
+      update_cache: yes
+      name:
+        - postgresql
+  - name: Copying main configuration file
+    copy:
+      src: postgresql.conf
+      owner: postgres
+      group: postgres
+      dest: "{{ config_path }}"
+      mode: '0600'
+  - name: Copying client authentication configuration file
+    copy:
+      src: pg_hba.conf
+      owner: postgres
+      group: postgres
+      dest: "{{ config_path }}"
+      mode: '0600'
+  - name: Ensuring PostgreSQL has been enabled and started
+    service:
+      name: postgresql
+      state: started
+      enabled: yes
\ No newline at end of file