GUC - Grand Unified Configuration
PostgreSQL's configuration system
GUC ("Grand Unified Configuration") is PostgreSQL's configuration system.
The Grand Unified Configuration (GUC) system was introduced in PostgreSQL 7.1 as a way to control PostgreSQL at various levels.
Source code
The overview in src/backend/utils/misc/README provides an introduction to adding configuration parameters, and is relevant for both for the core code and extensions.
See also src/backend/utils/misc/guc.c.
Change history
- PostrgreSQL 16
GUC_NO_RESETflag added (commit 38536642)
- PostgreSQL 8.3
- configuration parameters can be specified for functions with
ALTER FUNCTION ... [ SET | RESET ](commit 2abae34a)
- configuration parameters can be specified for functions with
- PostgreSQL 7.4
- support for read-only GUCs added (commit 9cbaf721)
- PostgreSQL 7.1
- added (commit 6a68f426)
References
- PostgreSQL documentation: Setting Parameters via the Configuration File
- PostgreSQL documentation: Parameter Interaction via SQL