1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
15
TITLE="System Catalogs"
16
HREF="catalogs.html"><LINK
19
HREF="view-pg-seclabels.html"><LINK
22
HREF="view-pg-shadow.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
57
HREF="view-pg-seclabels.html"
66
TITLE="System Catalogs"
74
>Chapter 45. System Catalogs</TD
80
TITLE="System Catalogs"
90
HREF="view-pg-shadow.html"
104
NAME="VIEW-PG-SETTINGS"
115
run-time parameters of the server. It is essentially an alternative
124
It also provides access to some facts about each parameter that are
125
not directly available from <TT
128
>, such as minimum and
146
><COL><COL><COL><THEAD
169
>Run-time configuration parameter name</TD
183
>Current value of the parameter</TD
197
>Implicit unit of the parameter</TD
211
>Logical group of the parameter</TD
225
>A brief description of the parameter</TD
239
>Additional, more detailed, description of the parameter</TD
253
>Context required to set the parameter's value (see below)</TD
298
>Source of the current parameter value</TD
312
>Minimum allowed value of the parameter (null for non-numeric
327
>Maximum allowed value of the parameter (null for non-numeric
342
>Allowed values of an enum parameter (null for non-enum
357
>Parameter value assumed at server startup if the parameter is
358
not otherwise set</TD
375
> would reset the parameter to
376
in the current session</TD
390
>Configuration file the current value was set in (null for
391
values set from sources other than configuration files, or when
392
examined by a non-superuser);
393
helpful when using <TT
396
> directives in configuration files</TD
410
>Line number within the configuration file the current value was
411
set at (null for values set from sources other than configuration files,
412
or when examined by a non-superuser)
419
> There are several possible values of <TT
423
In order of decreasing difficulty of changing the setting, they are:
437
> These settings cannot be changed directly; they reflect internally
438
determined values. Some of them may be adjustable by rebuilding the
439
server with different configuration options, or by changing options
453
> These settings can only be applied when the server starts, so any change
454
requires restarting the server. Values for these settings are typically
459
the command line when starting the server. Of course, settings with any
464
set at server start time.
474
> Changes to these settings can be made in
478
> without restarting the server.
482
> signal to the postmaster to
483
cause it to re-read <TT
487
the changes. The postmaster will also forward the
491
> signal to its child processes so that
492
they all pick up the new value.
502
> Changes to these settings can be made in
506
> without restarting the server;
507
they can also be set for a particular session in the connection request
508
packet (for example, via <SPAN
515
environment variable). However, these settings never change in a
516
session after it is started. If you change them in
524
> signal to the postmaster to cause it to
528
>. The new values will only
529
affect subsequently-launched sessions.
539
> These settings can be set from <TT
543
or within a session via the <TT
546
> command; but only superusers
547
can change them via <TT
554
> will affect existing sessions
555
only if no session-local value has been established with <TT
568
> These settings can be set from <TT
572
or within a session via the <TT
575
> command. Any user is
576
allowed to change his session-local value. Changes in
580
> will affect existing sessions
581
only if no session-local value has been established with <TT
591
HREF="config-setting.html"
593
> for more information about the various
594
ways to change these parameters.
600
> view cannot be inserted into or
601
deleted from, but it can be updated. An <TT
608
> is equivalent to executing
612
> command on that named
613
parameter. The change only affects the value used by the current
617
> is issued within a transaction
618
that is later aborted, the effects of the <TT
622
disappear when the transaction is rolled back. Once the surrounding
623
transaction is committed, the effects will persist until the end of the
624
session, unless overridden by another <TT
639
SUMMARY="Footer navigation table"
650
HREF="view-pg-seclabels.html"
668
HREF="view-pg-shadow.html"
b'\\ No newline at end of file'