ALTER SYSTEM

SQL-level command to modify the PostgreSQL configuration

ALTER SYSTEM is an SQL-level command to modify the PostgreSQL configuration.

ALTER SYSTEM was added in PostgreSQL 9.4 (commit 65d6e4cb).

Caveats

ALTER SYSTEM can only be executed by a superuser; it is not possible to wrap the command in a transaction or security definer function.

Source code

ALTER SYSTEM is handled by the function AlterSystemSetConfigFile() in src/backend/utils/misc/guc.c.

Change history

Categories

Configuration, SQL command

See also

postgresql.conf, postgresql.auto.conf