search

kostiantyn-nemchenko / ansible-role-patroni

:elephant: Ansible Role for Patroni
https://galaxy.ansible.com/kostiantyn-nemchenko/patroni
MIT License
68 stars 44 forks source link

Added host replication patroni_replication_username node/32 md5 #40

Closed patsevanton closed 5 years ago

patsevanton commented 5 years ago

@varmaraju @kostiantyn-nemchenko Please review pull request. This is PR with minimal changed for only run cluster. Before cluster can not run.

PR is work on ubuntu 16.04 (checked)

patsevanton commented 5 years ago

Please review pull request. This is PR with minimal changed for only run cluster. Before cluster can not run.

PR is work on ubuntu 16.04 (checked) Refactored patroni_bootstrap_pg_hba (copy and refactored https://github.com/kostiantyn-nemchenko/ansible-role-patroni/issues/37#issuecomment-440986839 )

Inventory

[all]
node1 ansible_host=192.168.88.94
node2 ansible_host=192.168.88.93
node3 ansible_host=192.168.88.92

[patroni]
node1
node2
node3

[etcd]
node1
node2
node3

[etcd-master]
node1
node2
node3
postgres@ubuntu:~$ cat /etc/patroni/node1.yml | grep -A 5 pg_hba 
  pg_hba:
    - host replication replicator 192.168.88.94/32 md5
    - host replication replicator 192.168.88.93/32 md5
    - host replication replicator 192.168.88.92/32 md5
  users:
    postgres:
+---------+--------+---------------+--------+---------+-----------+
| Cluster | Member |      Host     |  Role  |  State  | Lag in MB |
+---------+--------+---------------+--------+---------+-----------+
|   main  | node1  | 192.168.88.94 |        | running |       0.0 |
|   main  | node2  | 192.168.88.93 | Leader | running |       0.0 |
|   main  | node3  | 192.168.88.92 |        | running |       0.0 |
+---------+--------+---------------+--------+---------+-----------+