[github/fretlink/ansible-postgresql-role.git] / tasks / postgres-database.yml

- name: Test if the PostgreSQL server is up
  become: true
  become_user: postgres
  become_method: "{{ postgres_become_method }}"
  command: psql --port={{ postgres_port }} --command='select NOW()'
  register: postgres_up
  ignore_errors: yes
  check_mode: no
  changed_when: false

- name: Create PostgreSQL database
  become: true
  become_user: postgres
  become_method: "{{ postgres_become_method }}"
  postgresql_db:
    port:             "{{ postgres_port }}"
    name:             "{{ postgres_dbname }}"
    owner:            "{{ postgres_owner }}"
  when:
    - postgres_up.rc == 0

- name: Create database extensions
  include_tasks: postgres-database-extensions.yml
  loop: "{{ postgres_extensions| default([]) }}"
  loop_control:
    loop_var: postgres_extension
  when: postgres_up.rc == 0
Commit	Line	Data
d0bc90e0 P	1	- name: Test if the PostgreSQL server is up
	2	become: true
	3	become_user: postgres
29f3186f	4	become_method: "{{ postgres_become_method }}"
d0bc90e0 P	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
29f3186f	14	become_method: "{{ postgres_become_method }}"
d0bc90e0 P	15	postgresql_db:
	16	port: "{{ postgres_port }}"
	17	name: "{{ postgres_dbname }}"
	18	owner: "{{ postgres_owner }}"
	19	when:
	20	- postgres_up.rc == 0
4d626d5a P	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