Advertisement
Guest User

Untitled

a guest
May 30th, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  1. - name: Configure PostgreSQL streaming replication
  2. hosts: database_slave
  3.  
  4. pre_tasks:
  5. - name: Remove recovery.conf
  6. file:
  7. path: /var/lib/pgsql/9.4/data/recovery.conf
  8. state: absent
  9.  
  10. - name: Add slave to database group
  11. add_host:
  12. name: "{{ inventory_hostname }}"
  13. groups: database
  14. tags:
  15. - always
  16.  
  17. roles:
  18. - role: packages_el
  19. packages_el_install_tower: false
  20. packages_el_install_postgres: true
  21. when: ansible_os_family == "RedHat"
  22.  
  23. - role: postgres
  24. tags: postgresql_database
  25. postgres_allowed_ipv4: "0.0.0.0/0"
  26. postgres_allowed_ipv6: "::/0"
  27. postgres_username: "{{ pg_username }}"
  28. postgres_password: "{{ pg_password }}"
  29. postgres_database: "{{ pg_database }}"
  30. max_postgres_connections: 1024
  31. postgres_shared_memory_size: "{{ (ansible_memtotal_mb*0.3)|int }}"
  32. postgres_work_mem: "{{ (ansible_memtotal_mb*0.03)|int }}"
  33. postgres_maintenance_work_mem: "{{ (ansible_memtotal_mb*0.04)|int }}"
  34.  
  35.  
  36. - name: Configure master server
  37. hosts: database[0]
  38.  
  39. vars:
  40. postgresrep_master_address: "{{ hostvars[groups[postgresrep_group_name_master][0]].ansible_all_ipv4_addresses[0] }}"
  41. postgresrep_slave_address: "{{ hostvars[groups[postgresrep_group_name][0]].ansible_all_ipv4_addresses[0] }}"
  42.  
  43. roles:
  44. - postgres-replication
  45.  
  46. - name: Configure slave server
  47. hosts: database_slave
  48.  
  49. vars:
  50. postgresrep_master_address: "{{ hostvars[groups[postgresrep_group_name_master][0]].ansible_all_ipv4_addresses[0] }}"
  51. postgresrep_slave_address: "{{ hostvars[groups[postgresrep_group_name][0]].ansible_all_ipv4_addresses[0] }}"
  52.  
  53. roles:
  54. - postgres-replication
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement