Postgres Pro
Downloads
Home   >   mailing lists

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

From 周书林
Subject What is the difference between context of "sighup", "super-backend", and "backend" in pg_settings?
Date
Msg-id CAE0pyrsddqU=v3EH1nnU-Fy3kfhpZKE3d1ua51N2UZeZKiv3LA@mail.gmail.com
Whole thread Raw
Responses Re: What is the difference between context of "sighup", "super-backend", and "backend" in pg_settings?  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-general
Tree view
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"?

Sincerely,
Shulin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Difference between text_pattern_ops and varchar_pattern_ops
Next
From: Julien Rouhaud
Date:
Subject: Re: What is the difference between context of "sighup", "super-backend", and "backend" in pg_settings?