[github/fretlink/ansible-postgresql-role.git] / test / main.yml

---
- name: Bring up docker containers
  hosts: localhost
  vars: &common_vars
    postgres_version: 11
    postgres_barman_directory: 'test-postgres-11'
    postgres_barman_server: postgres_barman
    barman_rsync_password: "secret_rsync"
    barman_rsync_allowed_hosts: 172.17.0.0/24
    postgres_allowed_hosts:
      - user: all
        range: 172.17.0.0/24
    postgres_replication_hosts:
      - user: replicator
        range: 172.17.0.0/24
    inventory:
      - name: "{{ postgres_barman_server }}"
        image: "python:3.7-stretch"
      - name: postgres_one
        image: "python:3.7-stretch"
        links:
          - "{{ postgres_barman_server }}"
      - name: postgres_two
        image: "python:3.7-stretch"
        links:
          - "{{ postgres_barman_server }}"
          - postgres_one
      - name: postgres_three
        image: "python:3.7-stretch"
        links:
          - "{{ postgres_barman_server }}"
          - postgres_one
  roles:
    - role: provision_docker
      provision_docker_inventory: "{{inventory}}"
      provision_docker_use_docker_connection: true
  tasks:
    - name: Group primary
      add_host:
        hostname: "{{item}}"
        groups: primary
        <<: *common_vars
        postgres_clusters:
          - version: "{{ postgres_version }}"
            name: 'main'
            port: 5432
            fsync_enabled: True
            checksums: False
            archive_enabled: True
            barman_directory: "{{ postgres_barman_directory }}"
            users:
              - username: tester
                password: tester
              - username: barman
                password: "secret_cocktail"
                permissions: 'SUPERUSER'
              - username: replicator
                password: "secret_repli"
                permissions: 'REPLICATION'
            databases:
              - dbname: test_database
                owner: tester
                extensions:
                  - description: PostGis
                    apt_deps:
                      - "postgresql-{{ postgres_version }}-postgis"
                    names:
                      - postgis
                      - postgis_topology
                      - btree_gist

      with_items:
        - postgres_one
      tags: provision_docker

    - name: Group secondaries
      add_host:
        hostname: "{{item}}"
        groups: secondary
        <<: *common_vars
        postgres_clusters:
          - version: "{{ postgres_version }}"
            name: 'main'
            port: 5432
            fsync_enabled: True
            checksums: False
            archive_enabled: True
            barman_directory: "{{ postgres_barman_directory }}"
            primary:
              host: postgres_one
              port: 5432
              restore_directory: "{{ postgres_barman_directory }}"
              replication_user: "replicator"
              replication_password: "secret_repli"

      with_items:
        - postgres_two
        - postgres_three
      tags: provision_docker

    - name: Group db-all
      add_host:
        hostname: "{{item}}"
        groups: db-all
      with_items:
        - postgres_one
        - postgres_two
        - postgres_three
      tags: provision_docker

    - name: Group barman
      add_host:
        hostname: "{{item}}"
        groups: barman
        <<: *common_vars
        barman_databases:
          - name: "{{ postgres_barman_directory }}"
            description: 'Main database'
            primary_host: postgres_one
            primary_barman_password: "secret_cocktail"
            backup_method: rsync
            ansible_group: db-all
            retention_policy: 'RECOVERY WINDOW OF 7 DAYS'
      with_items:
        - postgres_barman
      tags: provision_docker

- name: Test installing Barman role
  hosts: barman
  connection: docker
  vars: {}
  pre_tasks: &pre_tasks
     - name: "Build hosts file"
       shell: 'echo "{{ hostvars[inventory_hostname].ansible_default_ipv4.address }} {{inventory_hostname}}" >> /etc/hosts'
       when: hostvars[inventory_hostname].ansible_default_ipv4.address is defined

     - debug: msg="Running on host {{inventory_hostname}} ({{ hostvars[inventory_hostname].ansible_default_ipv4.address }})"
  roles:
    - { role: barman, tags: ['barman'] }

- name: Test installing Postgresql role
  hosts: primary:secondary
  connection: docker
  vars:
    postgres_listen_addresses: "{{ hostvars[inventory_hostname].ansible_default_ipv4.address }}"
  pre_tasks: *pre_tasks
  roles:
    - { role: ansible-postgresql-role, tags: ['postgres'] }
  tasks:
    - name: Start postgres cluster
      service: name=postgresql state=started

    - name: Test connection to Postgres instances.
      become: true
      become_user: postgres
      become_method: su
      command: psql --port=5432 --command='select NOW()'


- name: Test running Postgresql role when database is started
  connection: docker
  hosts: primary:secondary
  vars:
    postgres_listen_addresses: "{{ hostvars[inventory_hostname].ansible_default_ipv4.address }}"
  pre_tasks: *pre_tasks
  roles:
    - { role: ansible-postgresql-role, tags: ['postgres'] }
Commit	Line	Data
d0bc90e0 P	1	---
	2	- name: Bring up docker containers
	3	hosts: localhost
	4	vars: &common_vars
91a1727f TH	5	postgres_version: 11
91a1727f TH	6	postgres_barman_directory: 'test-postgres-11'
d0bc90e0 P	7	postgres_barman_server: postgres_barman
	8	barman_rsync_password: "secret_rsync"
	9	barman_rsync_allowed_hosts: 172.17.0.0/24
	10	postgres_allowed_hosts:
	11	- user: all
	12	range: 172.17.0.0/24
	13	postgres_replication_hosts:
	14	- user: replicator
	15	range: 172.17.0.0/24
	16	inventory:
	17	- name: "{{ postgres_barman_server }}"
	18	image: "python:3.7-stretch"
	19	- name: postgres_one
	20	image: "python:3.7-stretch"
	21	links:
	22	- "{{ postgres_barman_server }}"
	23	- name: postgres_two
	24	image: "python:3.7-stretch"
	25	links:
	26	- "{{ postgres_barman_server }}"
	27	- postgres_one
	28	- name: postgres_three
	29	image: "python:3.7-stretch"
	30	links:
	31	- "{{ postgres_barman_server }}"
	32	- postgres_one
	33	roles:
	34	- role: provision_docker
	35	provision_docker_inventory: "{{inventory}}"
	36	provision_docker_use_docker_connection: true
	37	tasks:
	38	- name: Group primary
	39	add_host:
	40	hostname: "{{item}}"
	41	groups: primary
	42	<<: *common_vars
	43	postgres_clusters:
	44	- version: "{{ postgres_version }}"
	45	name: 'main'
	46	port: 5432
	47	fsync_enabled: True
	48	checksums: False
	49	archive_enabled: True
	50	barman_directory: "{{ postgres_barman_directory }}"
	51	users:
dd54b748 P	52	- username: tester
dd54b748 P	53	password: tester
d0bc90e0 P	54	- username: barman
	55	password: "secret_cocktail"
	56	permissions: 'SUPERUSER'
	57	- username: replicator
	58	password: "secret_repli"
	59	permissions: 'REPLICATION'
dd54b748 P	60	databases:
	61	- dbname: test_database
	62	owner: tester
	63	extensions:
	64	- description: PostGis
	65	apt_deps:
	66	- "postgresql-{{ postgres_version }}-postgis"
	67	names:
	68	- postgis
	69	- postgis_topology
	70	- btree_gist
d0bc90e0 P	71
	72	with_items:
	73	- postgres_one
	74	tags: provision_docker
	75
	76	- name: Group secondaries
	77	add_host:
	78	hostname: "{{item}}"
	79	groups: secondary
	80	<<: *common_vars
	81	postgres_clusters:
	82	- version: "{{ postgres_version }}"
	83	name: 'main'
	84	port: 5432
	85	fsync_enabled: True
	86	checksums: False
	87	archive_enabled: True
	88	barman_directory: "{{ postgres_barman_directory }}"
	89	primary:
	90	host: postgres_one
	91	port: 5432
	92	restore_directory: "{{ postgres_barman_directory }}"
	93	replication_user: "replicator"
	94	replication_password: "secret_repli"
	95
	96	with_items:
	97	- postgres_two
	98	- postgres_three
	99	tags: provision_docker
	100
	101	- name: Group db-all
	102	add_host:
	103	hostname: "{{item}}"
	104	groups: db-all
	105	with_items:
	106	- postgres_one
	107	- postgres_two
	108	- postgres_three
	109	tags: provision_docker
	110
	111	- name: Group barman
	112	add_host:
	113	hostname: "{{item}}"
	114	groups: barman
	115	<<: *common_vars
	116	barman_databases:
	117	- name: "{{ postgres_barman_directory }}"
	118	description: 'Main database'
	119	primary_host: postgres_one
	120	primary_barman_password: "secret_cocktail"
	121	backup_method: rsync
	122	ansible_group: db-all
	123	retention_policy: 'RECOVERY WINDOW OF 7 DAYS'
	124	with_items:
	125	- postgres_barman
	126	tags: provision_docker
	127
	128	- name: Test installing Barman role
	129	hosts: barman
	130	connection: docker
	131	vars: {}
	132	pre_tasks: &pre_tasks
	133	- name: "Build hosts file"
	134	shell: 'echo "{{ hostvars[inventory_hostname].ansible_default_ipv4.address }} {{inventory_hostname}}" >> /etc/hosts'
135	when: hostvars[inventory_hostname].ansible_default_ipv4.address is defined
136
137	- debug: msg="Running on host {{inventory_hostname}} ({{ hostvars[inventory_hostname].ansible_default_ipv4.address }})"
138	roles:
139	- { role: barman, tags: ['barman'] }
140
141	- name: Test installing Postgresql role
142	hosts: primary:secondary
143	connection: docker
144	vars:
145	postgres_listen_addresses: "{{ hostvars[inventory_hostname].ansible_default_ipv4.address }}"
146	pre_tasks: *pre_tasks
147	roles:
c4606fce	148	- { role: ansible-postgresql-role, tags: ['postgres'] }
d0bc90e0 P	149	tasks:
	150	- name: Start postgres cluster
	151	service: name=postgresql state=started
	152
	153	- name: Test connection to Postgres instances.
	154	become: true
	155	become_user: postgres
	156	become_method: su
	157	command: psql --port=5432 --command='select NOW()'
	158
	159
	160	- name: Test running Postgresql role when database is started
	161	connection: docker
	162	hosts: primary:secondary
	163	vars:
	164	postgres_listen_addresses: "{{ hostvars[inventory_hostname].ansible_default_ipv4.address }}"
	165	pre_tasks: *pre_tasks
	166	roles:
c4606fce	167	- { role: ansible-postgresql-role, tags: ['postgres'] }