| Lists: | pgsql-admin |
|---|
| From: | Francesco Dalla Ca' <f(dot)dallaca(at)cineca(dot)it> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Meaning of contexts from pg_settings view |
| Date: | 2006-05-08 12:31:20 |
| Message-ID: | 445F3A18.8020005@cineca.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
The following query, give six differents kind of context presents on the
system view pg_settings, that list all postgresql current parameters
setting.
postgres=# select distinct context from pg_settings;
context
------------
backend
internal
postmaster
sighup
superuser
user
(6 rows)
What's the mean for 'backend', 'postmaster' and 'sighup' context of a
parameter? How i can know if a parameter is modifiable only with a
server restart, rather than a 'pg_ctl reload' (sighup?) or a "SET/ALTER
USER/ALTER DATABASE" command?
Best regards,
Francesco.
--
--------------------------------------------------
Francesco Dalla Ca'
Settore Gestione Sistemi CINECA
Via Magnanelli 6/3 40033 Casalecchio di Reno (BO)
Bologna, Italy http://www.cineca.it
--------------------------------------------------
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Francesco Dalla Ca'" <f(dot)dallaca(at)cineca(dot)it> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Meaning of contexts from pg_settings view |
| Date: | 2006-05-08 14:49:19 |
| Message-ID: | 26887.1147099759@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
"Francesco Dalla Ca'" <f(dot)dallaca(at)cineca(dot)it> writes:
> What's the mean for 'backend', 'postmaster' and 'sighup' context of a
> parameter? How i can know if a parameter is modifiable only with a
> server restart, rather than a 'pg_ctl reload' (sighup?) or a "SET/ALTER
> USER/ALTER DATABASE" command?
The ones that say "postmaster" are the ones that require postmaster
restart.
regards, tom lane