postgresql_cluster
postgresql_cluster copied to clipboard
vitabaks
PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
With the release of version [2.0](https://github.com/vitabaks/postgresql_cluster/releases/tag/2.0.0), `postgresql_cluster` has been integrated with major cloud providers such as **AWS**, **GCP**, **Azure**, **DigitalOcean**, and **Hetzner Cloud**. **Proposal**: Add support for [Alibaba Cloud](https://www.alibabacloud.com/en), one...
With the release version [2.0](https://github.com/vitabaks/postgresql_cluster/releases/tag/2.0.0), we introduced a Console (UI) that provides an easy way to deploy clusters using a graphical interface. Now we are planning to add **Expert Mode**...
If the network is not specified, check for the default VPC. If no default VPC is found, a new VPC and subnet are created automatically. New variables: - `aws_vpc_name`, default...
This PR introduces a configurable `cluster_restore_timeout` variable to replace hardcoded values and provide flexibility. The timeout has been increased to 24 hours, making it more suitable for restoring large databases,...
Hey, first of all thanks for this project! Really appreciate the time and effort. I'm kinda stuck though, not really sure how to proceed. I've had a cluster running already,...
Need to update role according to master branch of role https://github.com/ansible-collections/ansible-consul. Fun starts from version 1.12.x See https://developer.hashicorp.com/consul/docs/upgrading/upgrade-specific#consul-1-12-x See https://developer.hashicorp.com/consul/docs/upgrading/upgrade-specific#consul-1-13-x See https://developer.hashicorp.com/consul/docs/upgrading/upgrade-specific#consul-1-14-x tls, addresses ,ports - are affected by these...
Hi. Thanks for your work. I based your role on a major upgrade of postgres and would like to share some of the cases I encountered. 1) Patroni precheck https://github.com/vitabaks/postgresql_cluster/blob/master/automation/pg_upgrade.yml#L19...
This is awesome! Would we be able to add more server types to the hetzner list? https://github.com/vitabaks/postgresql_cluster/blob/c9c9f02d0dd7991e3966f0e6c35dd4f3d3c45af0/console/db/migrations/20240520144338_2.0.0_initial_scheme_setup.sql#L295-L302 I could stitch together a PR - altho not sure if there's a...
From the first time I used the solution, I noticed that for Hetzner, no backup was installed because the provider doesn't support S3. I get it, but :) : 1....
I have done some experiment on the Hetzner provider to bench the performance local disk vs external volumes. My results: on a CCX23 4 dedicated CPU 16Gb RAM ## Local...