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');
Top comments (0)