Databases

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
  • Meaning of contexts from pg_settings view

    1 answers - 567 bytes - related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

    "Francesco Dalla Ca'" <f.dallaca (AT) cineca (DOT) itwrites:
    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
    (end of broadcast)
    TIP 3: Have you checked our extensive FAQ?
  • No.1 | | 653 bytes | |

    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.

Re: Meaning of contexts from pg_settings view


max 4000 letters.
Your nickname that display:
In order to stop the spam: 1 + 0 =
QUESTION ON "Databases"

EMSDN.COM