Re: [ADMIN] Meaning of contexts from pg_settings view

2006-05-08 Thread Tom Lane
"Francesco Dalla Ca'" <[EMAIL PROTECTED]> 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?

[ADMIN] Meaning of contexts from pg_settings view

2006-05-08 Thread Francesco Dalla Ca'
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