PostgreSQL 9.4 Документация
Выше

ALTER SYSTEM

Name

ALTER SYSTEM -- change a server configuration parameter

Synopsis

ALTER SYSTEM SET configuration_parameter { TO | = } { value | 'value' | DEFAULT }

Description

ALTER SYSTEM writes the configuration parameter values to the postgresql.auto.conf file. With DEFAULT, it removes a configuration entry from postgresql.auto.conf file. The values will be effective after reload of server configuration (SIGHUP) or in next server start based on the type of configuration parameter modified.

This command is not allowed inside transaction block or function.

See Section 18.1 for other ways to set the parameters and how they become effective.

Parameters

configuration_parameter

Name of a settable run-time parameter. Available parameters are documented in Глава 18.

value

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. DEFAULT can be written to specify to remove the parameter and its value from postgresql.auto.conf

Examples

Set the wal_level:

ALTER SYSTEM SET wal_level = hot_standby;

Set the authentication_timeout:

ALTER SYSTEM SET authentication_timeout = 10;

Compatibility

The ALTER SYSTEM statement is a PostgreSQL extension.

See Also

SET, SHOW
Начало
ALTER SERVER Выше ALTER TABLE
    Поддержать сайт на родительском проекте КГБ