postgresql_cluster
postgresql_cluster copied to clipboard
vitabaks
PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
How can we ensure in case of primary goes down and vip still points to the same server that my write operation always goes to primary server without failure. If...
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...
While executing the playbook I am getting below error: ``` TASK [haproxy : selinux | make sure the python3-libsemanage, python3-policycoreutils packages is present] **************************** ok: [167.71.227.220] ok: [143.110.249.159] TASK [haproxy...
I have encountered issue today. Playbook fails. See https://github.com/golang/go/issues/68107
Issue: https://github.com/vitabaks/postgresql_cluster/issues/589 As part of that PR, a database schema is being developed for the PostgreSQL cluster console. Tables: - `cloud_providers` - Table containing cloud providers information - `cloud_regions` -...
I have suddenly started getting OOM errors in my Postgres cluster . I have to restart the patroni to log in to the database. If I can log in by...
Line 50 in roles/ssh-keys/tasks/main.yml Change this from - anable_ssh_key_based_authentication is defined to - enable_ssh_key_based_authentication is defined
Hi, Is it possible to setup HA without internet? May I downloaded all dependencies and install manually then call the script to install HA cluster?
Issue: https://github.com/vitabaks/postgresql_cluster/issues/589
Hello I need to use `remove_cluster.yml`. You wrote in the Documentation follow Information:  But where or what is the safety Pin? Where to write `remove_postgres: true`...
