data_directory_mode
A read-only configuration parameter reporting the data directory permissions
data_directory_mode is a preset configuration parameter reporting the permissions of the data directory defined by the data_directory parameter at startup.
data_directory_mode was added in PostgreSQL 11.
Default value
The default value for data_directory_mode is: 0700.
Note that as a preset configuration parameter, data_directory_mode does not have a default value per-se. It can however be implicitly set when initialising a data directory with initdb using the option -g/--allow-group-access, or by manually setting the data directory permissions to one of:
0700(drwx------)0750(drwxr-x---)
before (re)starting PostgreSQL. Other combinations of permission settings are not permitted.
Change history
- PostgreSQL 15
- classification as
GUC_RUNTIME_COMPUTEDadded (commit 0c39c292)
- classification as
- PostgreSQL 11
- added (commit c37b3d08)
References
- PostgreSQL documentation: data_directory_mode