Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.40.0.2.32\))
Subject: Re: How to change mode for cluster log?
From: =?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>
In-Reply-To: 
 <CA+GVamEFyj1v8aRFPGmC3YXVUqJOodKV1PhHV4ETmUA5Ut0-Gw@mail.gmail.com>
Date: Tue, 26 Jan 2021 15:43:42 +0100
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <82C987F7-ADE4-4907-BB98-E36550134D67@gmail.com>
References: 
 <CA+GVamEFyj1v8aRFPGmC3YXVUqJOodKV1PhHV4ETmUA5Ut0-Gw@mail.gmail.com>
To: Binghan <binghanluc@gmail.com>
Precedence: bulk

Hi Binghan,

> On 26. Jan, 2021, at 15:33, Binghan <binghanluc@gmail.com> wrote:
>=20
> I have the following configuration in postgresql.conf. However, it =
only ensure the mode 600 for file under pg_log. The cluster log file =
postgresql-10-main.log has 640. How can control the mode for cluster log =
in postgres.=20
>=20
> logging_collector =3D off=09
> log_directory =3D '/var/log/postgresql/pg_log'
> log_filename =3D 'postgres-event.log'
> log_file_mode =3D 0600=09

you say, your file "postgresql-10-main.log" has 640 but your =
log_filename is "postgres-event.log". So the file =
"postgresql-10-main.log" is something else which your setup generates =
elsewhere.

In any event, you can enforce read/write permissions for a user only by =
setting its umask to 0077. Don't forget to change the permissions of =
your log file. The umask command does not change that!

Your should also make the setting persistent, for example in the profile =
of user postgres.

Cheers,
Paul=