How to integrate other modules with pg_auto_failover ?

[omyhub]

/var/lib/pgsql/17/data/postgresql-auto-failover.conf:
shared_preload_libraries = 'pg_stat_statements, timescaledb'

after pg_autoctl reload
shared_preload_libraries = pg_stat_statements

pg_autoctl --version
pg_autoctl version
pg_autoctl extension version 2.2
compiled with PostgreSQL 17.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-23), 64-bit
compatible with Postgres 13, 14, 15, 16 and 17

[talnetd]

yes this has been making me so mad. I can't find anywhere how to add another modules to load. Everytime I edit postgresql-auto-failover.conf: and restart pg_autoctl it just start up from clean up

[kevinelliott]

ALTER SYSTEM SET shared_preload_libraries = 'pg_stat_statements, timescaledb';

Then on restart of the node it'll keep.