postgresql_cluster
postgresql_cluster copied to clipboard
vitabaks
PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
Last week I did a major version upgrade with the playbook and encountered a few issues which I want to share. 1. During the upgrade `maintenance_enable` and `maintenance_disable` roles are...
Hi, Previously I am able to run the playbook using the old repo with everything inside postgresql_cluster/. Now I am trying to rebuild all the thing. I deleted the old...
Hi there! This project is *super cool*, thank you for making it. The HA situation in Postgres is frankly still quite complicated. I'm one of the makers of https://github.com/paradedb/paradedb. We'd...
This is an amazing ansible project that you've put together here, very impressive. I've set the project up to enable haproxy, cluster_vip and etcd, changed running on premise ( will...
Hi @vitabaks I have a question regarding the possibility of adding privileges for users. In the postgresql_cluster project, we can find roles for adding users, databases, and schemas, but there...
I have followed the most common scenario for deploying a cluster recently with HAProxy and pgbouncer. After maintaining this setup for a while I came up with understanding of the...
I'm testing the PITR and running the following . `ansible-playbook eploy_cluster.yml --tags point_in_time_recovery` I've set the following value in the main.yml: ``` patroni_cluster_bootstrap_method: "pgbackrest" patroni_create_replica_methods: #Uncomment pgbackrest only when restoring...
Hi @vitabaks , I am trying to deploy the cluster on /data path. I modified `etcd_data_dir` in vars/main.yml from `/var/lib/etcd` to` /data/var/lib/etcd`. But the etcd will fail to start. Beside,...