pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMeaning of contexts from pg_settings view
2+ messages / 2 participants
[nested] [flat]
* Meaning of contexts from pg_settings view
@ 2006-05-08 12:31 Francesco Dalla Ca' <f.dallaca@cineca.it>
0 siblings, 1 reply; 2+ messages in thread
From: Francesco Dalla Ca' @ 2006-05-08 12:31 UTC (permalink / raw)
To: 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
--------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Meaning of contexts from pg_settings view
@ 2006-05-08 14:49 Tom Lane <tgl@sss.pgh.pa.us>
parent: Francesco Dalla Ca' <f.dallaca@cineca.it>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2006-05-08 14:49 UTC (permalink / raw)
To: Francesco Dalla Ca' <f.dallaca@cineca.it>; +Cc: pgsql-admin
"Francesco Dalla Ca'" <f.dallaca@cineca.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-05-08 14:49 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-08 12:31 Meaning of contexts from pg_settings view Francesco Dalla Ca' <f.dallaca@cineca.it>
2006-05-08 14:49 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox