vitabaks / postgresql_cluster

PostgreSQL High-Availability Cluster (based on Patroni). Automating with Ansible.
https://postgresql-cluster.org
MIT License
1.54k stars 402 forks source link

Make keepalived more configurable #683

Closed abyss-ms closed 3 months ago

abyss-ms commented 3 months ago

It’d be nice to extend the keepalived role and make it possible to configure some options, for example, by adding the possibility of configuring more VIPs, virtual router IDs, and changing authentication. I'll prepare a PR for that and please let me know what you think about it. Thanks.

vitabaks commented 3 months ago

by adding the possibility of configuring more VIPs

@abyss-ms Could you please explain why it might be necessary to have more than one VIP address for a database cluster?

abyss-ms commented 3 months ago

Sure, in my case, there is a separate network for VPN traffic, allowing other sides to connect to the database (reporting application). Therefore, the VPN connection still has failover functionality.