From: "Michel SALAIS" <msalais@msym.fr>
To: "'still Learner'" <stilllearner23@gmail.com>
Cc: "'pgsql-admin'" <pgsql-admin@postgresql.org>
References: 
 <CAB3gP9+RQ3EdBCnW6JCmGL6vh+SnkD0kQwuD8pvLTE7ogEpZfw@mail.gmail.com>
 <00bd01d76435$2bf52790$83df76b0$@msym.fr>
 <CAB3gP9J=2+NVTdwf2aGkSKzGXTfVJ6i7GdRsRcC1tSheq9qa2A@mail.gmail.com>
In-Reply-To: 
 <CAB3gP9J=2+NVTdwf2aGkSKzGXTfVJ6i7GdRsRcC1tSheq9qa2A@mail.gmail.com>
Subject: RE: STDERR not logging after a fix log size
Date: Sat, 19 Jun 2021 22:29:33 +0200
Message-ID: <011401d76549$d11dfb60$7359f220$@msym.fr>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0115_01D7655A.94AC49A0"
Thread-Index: AQHS6LWsvTZce5WSpmOiYpIz/WC8OwI4mvvGAtNW5bmq/F70YA==
Content-Language: fr
Archived-At: 
 <https://www.postgresql.org/message-id/011401d76549%24d11dfb60%247359f220%24%40msym.fr>
Precedence: bulk

This is a multipart message in MIME format.

------=_NextPart_000_0115_01D7655A.94AC49A0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello,

=20

I don=E2=80=99t see a problem in your configuration. But your parameter =
log_rotation_age (1440 min =3D 1 day) will lead to a log rotation based =
on time and it is every day in your case. It will rotate on size only if =
you have more than 700MB of log per day.

=20

Michel SALAIS

=20

De : still Learner <stilllearner23@gmail.com>=20
Envoy=C3=A9 : vendredi 18 juin 2021 14:19
=C3=80 : Michel SALAIS <msalais@msym.fr>
Cc : pgsql-admin <pgsql-admin@postgresql.org>
Objet : Re: STDERR not logging after a fix log size

=20

@Michael Vitale, Yes I have done the reload.

=20

@Michel SALAIS, Please find the result of the query.

=20

=09

            name             |               setting               | =
unit=20
-----------------------------+-------------------------------------+-----=
-
 log_autovacuum_min_duration | 1000                                | ms
 log_checkpoints             | on                                  |=20
 log_connections             | on                                  |=20
 log_destination             | stderr                              |=20
 log_directory               | log                                 |=20
 log_disconnections          | off                                 |=20
 log_duration                | off                                 |=20
 log_error_verbosity         | default                             |=20
 log_executor_stats          | off                                 |=20
 log_file_mode               | 0600                                |=20
 log_filename                | postgresql-%Y-%m-%d_%H%M%S.log      |=20
 log_hostname                | off                                 |=20
 log_line_prefix             | %t [%p]: [%h] [%l-1] user=3D%u,db=3D%d  | =

 log_lock_waits              | on                                  |=20
 log_min_duration_statement  | 2000                                | ms
 log_min_error_statement     | error                               |=20
 log_min_messages            | warning                             |=20
 log_parser_stats            | off                                 |=20
 log_planner_stats           | off                                 |=20
 log_replication_commands    | off                                 |=20
 log_rotation_age            | 1440                                | min
 log_rotation_size           | 716800                              | kB
 log_statement               | none                                |=20
 log_statement_stats         | off                                 |=20
 log_temp_files              | -1                                  | kB
 log_timezone                | Asia/Kolkata                        |=20
 log_truncate_on_rotation    | off                                 |=20
 logging_collector           | on                                  |=20
(28 rows)

=20

On Fri, Jun 18, 2021 at 4:59 PM Michel SALAIS <msalais@msym.fr =
<mailto:msalais@msym.fr> > wrote:

Hi,

=20

What is the result of the following query?

=20

Select name, setting, unit