Postgres Pro
Downloads
Home   >   mailing lists

Re: Meaning of contexts from pg_settings view - Mailing list pgsql-admin

From Tom Lane
Subject Re: Meaning of contexts from pg_settings view
Date
Msg-id 26887.1147099759@sss.pgh.pa.us
Whole thread Raw
In response to Meaning of contexts from pg_settings view  (Francesco Dalla Ca' <f.dallaca@cineca.it>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: Francesco Dalla Ca'
Date:
Subject: Meaning of contexts from pg_settings view
Next
From: "Jim C. Nasby"
Date:
Subject: Re: OIDs wraparaound: postgresql (different versions) behavior