Re: Meaning of contexts from pg_settings view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Francesco Dalla Ca'" <f(dot)dallaca(at)cineca(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Meaning of contexts from pg_settings view
Date: 2006-05-08 14:49:19
Message-ID: 26887.1147099759@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Francesco Dalla Ca'" <f(dot)dallaca(at)cineca(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-05-08 18:00:26 Re: OIDs wraparaound: postgresql (different versions) behavior
Previous Message Francesco Dalla Ca' 2006-05-08 12:31:20 Meaning of contexts from pg_settings view