Vitaliy Kukharik

@syu-lk4b Hi! I had no experience in production with this version of pgbouncer. At this stage, I have no plans to implement it. But I will be grateful for PR.

Hi @RoyGRad ! please show what you have specified in vars/system.yml `sysctl_conf` variable

Yes, you can ignore it, but I would like to understand the reason for the error

In my case it works (ubuntu 22.04) ``` TASK [sysctl : Setting kernel parameters] ******************************************************************************************************************************************************************** ok: [172.31.17.229] => (item={'name': 'vm.overcommit_memory', 'value': '2'}) ok: [172.31.17.229] => (item={'name': 'vm.swappiness', 'value': '1'}) ok:...

at first glance, the variables are specified correctly if you don't use iptables, I recommend commenting out the "net.netfilter.nf_conntrack_max" parameter See commit a911cb56c6680c25b7b0cc2c08033ccacb4b6a07

please provide information for debugging `ansible-playbook deploy_pgcluster.yml --tag sysctl -vvv >> ansible_sysctl.log`

Hi @nishantcha1997 If you are using pgbouncer, then after adding a new user, you also need to add this user to the pgbouncer configuration `/etc/pgbouncer/userlist.txt`. #### how to add a...

I will be grateful for your PR

**Example for:** Installation on: `СentOS` PostgresPro version: `12.4.1` :heavy_exclamation_mark: To use any version of Postgres Pro in production, **you must purchase a license**. 1. **Add PostgresPro repository** (v12.4.1) for CentOS...

Tested with Postgres Pro Standard 12.2.1 on Centos 7 and 8.