Changing Parameters in pg_auto_failover Multi-Node Setup

[krishnakongara123]

Hi everyone,

I have a multi-node pg_auto_failover setup with PostgreSQL 16 and I need to change some configuration parameters, such as max_connections. I’m unsure about the best approach for this. Specifically:

Which configuration file should I modify for changes like max_connections? Should I update postgresql.conf, or is it better to modify postgresql-auto-failover.conf?

Is there a way to make these changes without triggering a failover event? I want to avoid using pg_autoctl stop and pg_autoctl run if possible. Is there a procedure to apply the changes smoothly?

Can I use the pg_autoctl config set command to change these parameters? If so, could you provide an example of how to do this?

Thank you in advance for your help!

Best regards,
Siva