2
2
.\" Title: ALTER SYSTEM
3
3
.\" Author: The PostgreSQL Global Development Group
4
4
.\" Generator: DocBook XSL Stylesheets v1.76.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.4beta3 Documentation
7
.\" Source: PostgreSQL 9.4beta3
6
.\" Manual: PostgreSQL 9.4.1 Documentation
7
.\" Source: PostgreSQL 9.4.1
8
8
.\" Language: English
10
.TH "ALTER SYSTEM" "7" "2014" "PostgreSQL 9.4beta3" "PostgreSQL 9.4beta3 Documentation"
10
.TH "ALTER SYSTEM" "7" "2015" "PostgreSQL 9.4.1" "PostgreSQL 9.4.1 Documentation"
11
11
.\" -----------------------------------------------------------------
12
12
.\" * Define some portability stuff
13
13
.\" -----------------------------------------------------------------
44
writes the configuration parameter values to the
44
is used for changing server configuration parameters across the entire database cluster\&. It can be more convenient than the traditional method of manually editing the
48
writes the given parameter setting to the
45
49
postgresql\&.auto\&.conf
46
file\&. Setting the parameter to
50
file, which is read in addition to
51
postgresql\&.conf\&. Setting a parameter to
47
52
DEFAULT, or using the
49
variant, removes the configuration entry from
54
variant, removes that configuration entry from the
50
55
postgresql\&.auto\&.conf
53
to clear all configuration entries\&. The values will be effective after reload of server configuration (SIGHUP) or in next server start based on the type of configuration parameter modified\&.
55
This command is not allowed inside transaction block or function\&.
58
Section 18.1, \(lqSetting Parameters\(rq, in the documentation
59
for other ways to set the parameters and how they become effective\&.
58
to remove all such configuration entries\&.
62
will be effective after the next server configuration reload (SIGHUP
64
pg_ctl reload), or after the next server restart in the case of parameters that can only be changed at server start\&.
66
Only superusers can use
67
\fBALTER SYSTEM\fR\&. Also, since this command acts directly on the file system and cannot be rolled back, it is not allowed inside a transaction block or function\&.
62
70
\fIconfiguration_parameter\fR
64
Name of a settable run\-time parameter\&. Available parameters are documented in
72
Name of a settable configuration parameter\&. Available parameters are documented in
65
73
Chapter 18, Server Configuration, in the documentation\&.
70
New value of parameter\&. Values can be specified as string constants, identifiers, numbers, or comma\-separated lists of these, as appropriate for the particular parameter\&.
78
New value of the parameter\&. Values can be specified as string constants, identifiers, numbers, or comma\-separated lists of these, as appropriate for the particular parameter\&.
72
can be written to specify to remove the parameter and its value from
73
postgresql\&.auto\&.conf
80
can be written to specify removing the parameter and its value from
81
postgresql\&.auto\&.conf\&.
77
85
This command can\*(Aqt be used to set
79
and any parameters (e\&.g\&.,
80
preset options) that are not allowed in
86
data_directory, nor parameters that are not allowed in
92
Section 18.1, \(lqSetting Parameters\(rq, in the documentation
93
for other ways to set the parameters\&.