From d9b64e65057fd6c934a207fc0141b1be9db3c6bc Mon Sep 17 00:00:00 2001 From: Hari Babu Date: Mon, 4 Feb 2019 12:05:33 +1100 Subject: [PATCH] log_file_mode recommended value update For group read access cluster, the recommended value of log_file_mode is 0640 to allow reading of log files by the members of the same group --- doc/src/sgml/config.sgml | 15 ++++++++++----- 1 file changed, 10 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index b6f5822b84..9308dc1f89 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -5443,11 +5443,16 @@ local0.* /var/log/postgresql 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 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. + group to read the files. + + + Permissions 0640 are recommended to be compatible with + initdb option . + + + Note however that to make use of any settings other than recommended, + you'll need to alter to store the files + somewhere outside the cluster data directory. This parameter can only be set in the postgresql.conf -- 2.20.1.windows.1