postgresql_cluster
postgresql_cluster copied to clipboard
vitabaks
PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
### Bug description Hi, I've encountered with this error: ``` The conditional check 'item.option == 'log-path'' failed. The error was: error while evaluating conditional (item.option == 'log-path'): 'item' is undefined...
### Bug description ``` TASK [vitabaks.autobase.deploy_finish : Get Postgres databases: main.yml] ************************************************************ Friday 30 May 2025 05:56:56 +0000 (0:00:07.721) 0:09:30.317 ************ fatal: [db-192-168-80-4 -> db-192-168-80-3]: UNREACHABLE! => {"changed": false, "msg":...
currently if we try to create ec2 instance in aws in private subnet due to `assign_public_ip` set to `true`, even in private subnet the instance tries to assign public ip...
### Problem In my case `inventory_hostname` ansible variable is set to a string that is not an actual IP-address of a host but looks like `nonprod-db-10-9-12-189`. It breaks all config...
### Bug description https://github.com/vitabaks/autobase/blob/8969ea83c3210a152b1d0a9f9163841ca19ea576/automation/roles/consul/tasks/config.yml#L4 This task is supposed to generate a valid json file, but instead it generates a string, that looks like json: `+"{'datacenter': 'dc1', 'domain': 'consul', 'performance': {'raft_multiplier':...
Add two new roles to deploy and configure Prometheus exporters: - [node_exporter](https://github.com/prometheus/node_exporter) - [postgres_exporter](https://github.com/prometheus-community/postgres_exporter)
So far this was only able when using `cloud-provider`. Now, one can set `backup_provider` to one of the mentioned options and backup to S3 through `pgbackrest` when the `autobase` cluster...
Add support for RHEL 10-based distributions: - CentOS Stream 10 - Rocky Linux 10 - AlmaLinux 10 - Oracle Linux 10 ### Description With the release of [CentOS Stream 10](https://www.centos.org/download/)...
### Bug description Noticed that I was not able to deploy etcd properly on clean SSH machines. Failing at: ``` TASK [etcd : Wait for port 2379 to become open...
