allow_system_table_mods Developer Parameter

Type: bool
Default: off
Context: superuser
Restart: false

Allows modification of the structure of system tables as well as certain other risky actions on system tables. This is otherwise not allowed even for superusers. Ill-advised use of this setting can cause irretrievable data loss or seriously corrupt the database system. Only superusers and users with the appropriate SET privilege can change this setting.

Recommendations

Only available in single-user mode; this setting is for initdb and may be used in the future for upgrade-in-place.

Comments