PostgreSQL DBA

Patroni

Question

Patroni dynamic configuration versus local patroni.yml: what differs, and when should each be used?

Answer

Dynamic configuration lives in the DCS and applies to all members. Local patroni.yml is per node and overrides dynamic values, except Patroni-controlled parameters like max_connections and wal_level, whose local values are ignored. Use dynamic for cluster-wide PostgreSQL and HA policy; local for node addresses, paths, credentials.

This is 18 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples