postgresql_cluster
postgresql_cluster copied to clipboard
vitabaks
PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
This PR is related to #582. Although this is a trivial change, I think that quite a few people could incur in the requirement of having to enable TLS at...
Issue: https://github.com/vitabaks/postgresql_cluster/issues/458 1. **Provision of cloud resources (virtual machine + disk)** to a popular cloud providers for PostgreSQL cluster deployment: - [x] AWS - [x] GCP - [x] Azure -...
Hi everyone! We just finished configuring the PostgreSQL cluster, and everything looks great! We have set up the SSL connection for the cluster. However, when we try to connect to...
Hello everyone, I might be wrong, but it seems to me that the playbooks search for variables in hardcoded paths (namely `vars/main.yml`). This, I think, makes it a bit harder...
hello agian , i don't know why when i reboot a replica server I can't ssh it give me . 22 port refused after , maybe because something in playbook
hello , i don't why this error show ..? the ports its open in both of server in vi vars/main.yml ``` patroni_cluster_bootstrap_method: "basebackup" # or "wal-g", "pgbackrest", "pg_probackup" # https://patroni.readthedocs.io/en/latest/replica_bootstrap.html#building-replicas...
I have added below entries in vars/main.yml file : ``` log_checkpoints = on log_connections = on log_disconnections =on log_lock_waits=0 log_temp_files=0 log_autovacuum_min_duration=0 log_error_verbosity=default log_statement=off log_min_duration_statement=10 log_line_prefix = '%t [%p]: db=%d,user=%u,app=%a,client=%h '...
Currently, scaling of Postgres nodes using playbook `add_pgnode.yml` and scaling of HAProxy nodes using playbook `add_balancer.yml` is implemented, but for etcd or consul cluster, only the initial deploument is automated...
Hi @vitabaks , I have a question about failover with a secondary/replica multi regions. Using EC2, I plan to deploy four instances across two regions, with us-west-2 as the master...
What is wrong with my config (below)? Tried these tutorials https://www.haproxy.com/blog/howto-transparent-proxying-and-binding-with-haproxy-and-aloha-load-balancer/ https://serverfault.com/questions/980615/haproxy-unable-to-switch-to-transparent-mode but still no success, can't conect to pgbouncer
