feat(postgresql): add ansible role for postgresql deployment

galaxy.yml

@@ -1,13 +1,12 @@
 namespace: finallycoffee
 name: databases
-version: 0.1.2
+version: 0.1.1
 readme: README.md
 authors:
 - transcaffeine <transcaffeine@finally.coffee>
 description: Collection for deploying and configuring databases
 dependencies:
-  "community.docker": "^4.0.0"
-  "community.postgresql": "^3.9.0"
+  "community.docker": "^3.0.0"
 license_file: LICENSE.md
 build_ignore:
 - '*.tar.gz'

roles/postgresql/tasks/configure.yml

@@ -50,7 +50,6 @@
       loop_control:
         loop_var: result
         label: "{{ result.option.key }}"
-  when: postgresql_state == 'present'
   vars:
     postgresql_login_host: >-2
       {{

roles/postgresql/tasks/deploy-local.yml

@@ -1,11 +0,0 @@
----
-- name: Ensure postgresql package is {{ postgresql_state }}
-  ansible.builtin.package:
-    name: "{{ postgresql_os_package_name }}"
-    state: "{{ postgresql_state }}"
-
-- name: Ensure postgresql systemd unit is {{ (postgresql_state == 'present') | ternary('enabled', 'disabled') }}
-  ansible.builtin.systemd:
-    name: "{{ postgresql_systemd_service_name }}"
-    enabled: "{{ (postgresql_state == 'present') }}"
-  when: ansible_facts['service_mgr'] == 'systemd'

roles/postgresql/tasks/main.yml

@@ -33,7 +33,6 @@
   loop:
     - name: "{{ postgresql_config_path }}"
     - name: "{{ postgresql_data_path }}"
-      mode: "0700"
   loop_control:
     loop_var: path
     label: "{{ path.name }}"

roles/postgresql/tasks/prepare.yml

@@ -22,7 +22,6 @@
       insert_after: "# Ansible managed"
       line: "{{ postgresql_admin_pg_ident_conf }}"
   when: postgresql_state == 'present'
-  notify: postgresql_restart
 
 - name: Configure permissions for postgresql admin role
   community.postgresql.postgresql_pg_hba:
@@ -32,4 +31,3 @@
     method: "{{ postgresql_admin_role_method }}"
     options: "{{ postgresql_admin_pg_hba_conf_options }}"
   when: postgresql_state == 'present'
-  notify: postgresql_restart

roles/postgresql/vars/main.yml

@@ -4,4 +4,3 @@ postgresql_states:
   - absent
 postgresql_deployment_methods:
   - docker
-  - local