postgresql_cluster

postgresql_cluster copied to clipboard

Pgbouncer with LDAP

1

just a basic question. three years ago, the pgbouncer was not compatible with LDAP authentication. is there something we can do to set up connection pooling with LDAP as we...

kumarashish071092

TODO: Automate Database Monitoring setup

1

- [ ] [Netdata](https://github.com/netdata/netdata) (if `netdata_install: true`) - [x] System metrics - [PR](https://github.com/vitabaks/autobase/pull/904) - [x] Postgres metrics - [PR](https://github.com/vitabaks/autobase/pull/904) - [ ] Pgbouncer metrics - TODO - [ ] Patroni...

vitabaks

TODO: Implement zero-downtime major upgrades (blue/green)

3

In the previous release ([1.8.0](https://github.com/vitabaks/postgresql_cluster/releases/tag/1.8.0)), we introduced automation for in place major upgrades with minimal downtime (see [PR #301](https://github.com/vitabaks/postgresql_cluster/pull/301)). \ While this was a significant improvement, there is still a...

vitabaks

Extend Deployment method to create Infrastructure in Multiple Cloud Providers

1

Enhance Deployment Capabilities to Include Infrastructure Creation in Multiple Cloud Providers. **Description:** Currently, the project supports deploying a PostgreSQL cluster on pre-existing VMs or physical servers. We should extend this...

vitabaks

Patroni restapi authentication question

1

Hi. Is there any reason why authentication is not enabled at the [patroni restapi configuration](https://github.com/vitabaks/postgresql_cluster/blob/f8b74576c34f17c2fd33d28c8f7bd2b74941628f/roles/patroni/templates/patroni.yml.j2#L28) or this is just an error?

alkorgun

Patroni pre-checks: check etcd cluster accessible

1

I suggest checking the network availability of the etcd cluster before adding nodes to the Patroni cluster. If etcd is unavailable for some reason, don't even attempt to add the...

lavr

Request for Adding service Feature and to a more modular Postgres Installation

5

Hello, I would like to suggest an improvement that I believe could benefit numerous users. **Postgres Installation as a Service (systemd)**: Currently, I do not see an option in the...

ThomasSanson

TODO: Citus cluster support (Postgres sharding)

2

With [Citus](https://github.com/citusdata/citus) you get distributed Postgres features like sharding, distributed tables, reference tables, a distributed query engine, columnar storage, and the ability to query from any node.  #### What...

vitabaks

Add ansible_host with fallback on etcd,pg_hba, haproxy conf

6

Hi @vitabaks, This PR introduce the usage of `ansible_host` that can be used in inventory to specify IP of machine, instead usage of `inventory_hostname`. I notice in the invnetory example...

tanganellilore

Migration to Ansible Collection Format

8

Currently, PostgreSQL High-Availability Cluster installation via Ansible is done using the "role" mode. However, the "collection" format is now the recommended deployment method for Ansible. I am requesting a migration...

ThomasSanson