What is the difference between context of "sighup", "super-backend", and "backend" in pg_settings?

On Sat, Jun 26, 2021 at 12:56:21PM +0800, 周书林 wrote:

Hi,

I am interested in the configuration parameter of Postgres. I found that
the configuration parameters in context of "sighup", "super-backend", and
"backend" are all required to send "SIGHUP" signal to postmaster for
rereading configuration files. So my question is, what is the difference
between them, except for the super-usre privilege requirment between
"super-backend", and "backend"?

Please refer to the documentation for an exhaustive description:
https://www.postgresql.org/docs/current/view-pg-settings.html