Meaning of contexts from pg_settings view

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-05-08 14:49:19 Re: Meaning of contexts from pg_settings view
Previous Message Francesco Dalla Ca' 2006-05-08 10:09:13 OIDs wraparaound: postgresql (different versions) behavior