Move pg_hba conf into patroni.yml

[rausub]

If we move pg_hba.conf into patroni.xml instead of deploying using template. It would be great to have the ability to use patronictl edit-config which would allow pg_hba changes cluster wide for on demand admin tasks.

https://github.com/vitabaks/autobase/blob/master/automation/roles/patroni/templates/pg_hba.conf.j2

[vitabaks]

This is not really necessary, as autobase updates the configuration on all servers at once.

We personally do not use edit-config

[rausub]

yep i understand, what i was trying to say for ad-hoc emergency/maintenance works having ability to do it via edit-config would be great.

[vitabaks]

We need to review the code more closely, as I don’t remember why I decided to hand over control of pg_hba to Autobase instead of Patroni. If there are no strong reasons for this choice, it might be worth considering adding the option to manage pg_hba through Patroni.

[rausub]

Yeah i was also trying to find a good reason for how it is currently designed and I couldn't think of it. Please let us know if there is a reason. Appreciate all your efforts.