#dba

PostgreSQL – which configurations require a service restart

To determine whether a PostgreSQL configuration change requires a service restart, query select name, context from pg_settings. If the context is postmaster, the setting requires a restart; otherwise a reload is sufficient.