pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Meaning 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