[github/fretlink/ansible-postgresql-role.git] / tasks / postgres-user.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 user
  become: true
  become_user: postgres
  become_method: "{{ postgres_become_method }}"
  postgresql_user:
    port:             "{{ postgres_port }}"
    name:             "{{ postgres_username }}"
    password:         "{{ postgres_password }}"
    encrypted:        true
    role_attr_flags:  "{{ postgres_permissions }}"
  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 user
	12	become: true
	13	become_user: postgres
29f3186f	14	become_method: "{{ postgres_become_method }}"
d0bc90e0 P	15	postgresql_user:
	16	port: "{{ postgres_port }}"
	17	name: "{{ postgres_username }}"
	18	password: "{{ postgres_password }}"
	19	encrypted: true
	20	role_attr_flags: "{{ postgres_permissions }}"
	21	when:
	22	- postgres_up.rc == 0