tasks/postgres-user.yml

   1 - name: Test if the PostgreSQL server is up
   2   become: true
   3   become_user: postgres
   4   become_method: "{{ postgres_become_method }}"
   5   command: psql --port={{ postgres_port }} --command='select NOW()'
   6   register: postgres_up
   7   ignore_errors: yes
   8   check_mode: no
   9   changed_when: false
  10
  11 - name: "Install required packages for 'postgres_user' ansible module"
  12   apt:
  13     name:
  14       - libpq-dev
  15       - python-psycopg2
  16
  17 - name: Create PostgreSQL user
  18   become: true
  19   become_user: postgres
  20   become_method: "{{ postgres_become_method }}"
  21   postgresql_user:
  22     port:             "{{ postgres_port }}"
  23     name:             "{{ postgres_username }}"
  24     password:         "{{ postgres_password }}"
  25     encrypted:        true
  26     role_attr_flags:  "{{ postgres_permissions }}"
  27   when:
  28     - postgres_up.rc == 0