tasks/postgres-database.yml

   1 - name: Test if the PostgreSQL server is up
   2   become: true
   3   become_user: postgres
   4   become_method: su
   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: Create PostgreSQL database
  12   become: true
  13   become_user: postgres
  14   become_method: su
  15   postgresql_db:
  16     port:             "{{ postgres_port }}"
  17     name:             "{{ postgres_dbname }}"
  18     owner:            "{{ postgres_owner }}"
  19   when:
  20     - postgres_up.rc == 0
  21
  22 - name: Create database extensions
  23   include_tasks: postgres-database-extensions.yml
  24   loop: "{{ postgres_extensions| default([]) }}"
  25   loop_control:
  26     loop_var: postgres_extension
  27   when: postgres_up.rc == 0