Setting and Displaying Patroni's Max Connection Count

Patroni configuration are mainly stored in patroni.yaml. Find the path of that yaml.

Not: Patroni configurations are primarily stored in patroni.yaml. Find the path to that YAML file.

This command lists Patroni clusters and hosts.

patronictl -c /etc/patroni.yml list

To edit PostgreSQL settings in Patroni, you can use the 'edit-config' command.

patronictl -c /etc/patroni.yaml edit-config

Modify the 'max_connections' line within 'postgresql.parameters', and create it if it does not already exist.

.
postgresql
  parameters
    max_connections: 200
.

To display the maximum monitor count, you can connect to your Patroni cluster using psql, and then run the script below to show the maximum connection count.

To query to patroni server we can use below comamnd:

psql -h <patroni_ha_ip> -U <username> -p <ha_db_port> -W

On psql

SHOW max_connections;

OR

SELECT current_setting('max_connections');