Vitaliy Kukharik

Consul support is planned. It is necessary to allocate time - https://github.com/vitabaks/postgresql_cluster/issues/85 --- _Make your contribution to the development of the project, become a [sponsor](https://www.patreon.com/vitabaks)_

Hi @torquemada163 In your example is missing the `"}` for "net.ipv4.ip_local_port_range" See https://github.com/vitabaks/postgresql_cluster/blob/master/vars/system.yml#L59

the playbook supports a different postgresql_data_dir, I'll check it

> In our setup, we would like to be able to configure the port that the Patroni API is listening on. why?

All checks have failed The error appears to be in '/github/workspace/roles/patroni/tasks/main.yml': line 757, column 16, but may be elsewhere in the file depending on the exact syntax problem. The offending...

@asobeeh There may be many reasons because of which your application cannot connect to the database. For example, network problems. If you use pgbouncer connection pooler, make sure that you...

@asobeeh Are these related issues https://github.com/vitabaks/postgresql_cluster/issues/94 ?

How many connections does your application create? `select count(*) from pg_stat_activity;` Is your application using persistent connections? Check out Are there any errors in the postgresql log?

> Yes presistant connection check tcp_keepalive* settings. http://postgresql.freeideas.cz/hanging-postgresql-session-called-go-lang-node-js-program/ https://stackoverflow.com/questions/31259154/database-hangs-if-not-used or try to increase the value for haproxy timeouts `/etc/confd/templates/haproxy.tmpl`

timescaledb repository for **RHEL/CentOS 7/8** (in the [/vars/RedHat.yml](https://github.com/vitabaks/postgresql_cluster/blob/master/vars/RedHat.yml) variable file) ``` yum_repository: - name: "timescale_timescaledb" description: "timescaledb repo" baseurl: "https://packagecloud.io/timescale/timescaledb/el/{{ ansible_distribution_major_version }}/x86_64" gpgkey: "https://packagecloud.io/timescale/timescaledb/gpgkey" gpgcheck: "no" ```