| 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.
On StackOverflow
On pgsql-hackers
- restrict_nonsystem_relation_kind led to regression (kinda)
- Re: Truncation of mapped catalogs (whether local or shared) leads to server crash
- Re: Possibilities on code change to implement pseudodatatypes
- Truncation of mapped catalogs (whether local or shared) leads to server crash
- gist index builds try to open FSM over and over