pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francesco Dalla Ca' <f.dallaca@cineca.it>
To: pgsql-admin@postgresql.org
Subject: Meaning of contexts from pg_settings view
Date: Mon,  8 May 2006 14:31:20 +0200 (MEST)
Message-ID: <445F3A18.8020005@cineca.it> (raw)

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
-------------------------------------------------- 




view thread (2+ messages)  latest in thread

Message-ID: <445F3A18.8020005@cineca.it>
Permalink:  ../445F3A18.8020005@cineca.it/
Also on:    postgresql.org/message-id/445F3A18.8020005@cineca.it

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: f.dallaca@cineca.it
  Subject: Re: Meaning of contexts from pg_settings view
  In-Reply-To: <445F3A18.8020005@cineca.it>
  References: <445F3A18.8020005@cineca.it>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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