On Unix systems this parameter sets the permissions for log files when logging_collector is enabled. (On Microsoft Windows this parameter is ignored.) The parameter value is expected to be a numeric mode specified in the format accepted by the chmod and umask system calls. (To use the customary octal format the number must start with a
The default permissions are
0600, meaning only the server owner can read or write the log files. The other commonly useful setting is
0640, allowing members of the owner's group to read the files. Note however that to make use of such a setting, you'll need to alter log_directory to store the files somewhere outside the cluster data directory. In any case, it's unwise to make the log files world-readable, since they might contain sensitive data.
This parameter can only be set in the postgresql.conf file or on the server command line.
- Postgresql pgadmin log can't work
- How to customize the configuration file of the official PostgreSQL Docker image?
- How to findout which object is not in prerequisite state in postgres?
- Selecting from pg_catalog.pg_settings got slow after updating to PostgreSQL 12 (windows)
- What data entered into postgres