RE: STDERR not logging after a fix log size

Hello,

I don’t see a problem in your configuration. But your parameter log_rotation_age (1440 min = 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.

Michel SALAIS

De : still Learner <stilllearner23(at)gmail(dot)com>
Envoyé : vendredi 18 juin 2021 14:19
À : Michel SALAIS <msalais(at)msym(dot)fr>
Cc : pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Objet : Re: STDERR not logging after a fix log size

@Michael Vitale, Yes I have done the reload.

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

name | setting | unit
-----------------------------+-------------------------------------+------
log_autovacuum_min_duration | 1000 | ms
log_checkpoints | on |
log_connections | on |
log_destination | stderr |
log_directory | log |
log_disconnections | off |
log_duration | off |
log_error_verbosity | default |
log_executor_stats | off |
log_file_mode | 0600 |
log_filename | postgresql-%Y-%m-%d_%H%M%S.log |
log_hostname | off |
log_line_prefix | %t [%p]: [%h] [%l-1] user=%u,db=%d |
log_lock_waits | on |
log_min_duration_statement | 2000 | ms
log_min_error_statement | error |
log_min_messages | warning |
log_parser_stats | off |
log_planner_stats | off |
log_replication_commands | off |
log_rotation_age | 1440 | min
log_rotation_size | 716800 | kB
log_statement | none |
log_statement_stats | off |
log_temp_files | -1 | kB
log_timezone | Asia/Kolkata |
log_truncate_on_rotation | off |
logging_collector | on |
(28 rows)

On Fri, Jun 18, 2021 at 4:59 PM Michel SALAIS <msalais(at)msym(dot)fr <mailto:msalais(at)msym(dot)fr> > wrote:

Hi,

What is the result of the following query?

Select name, setting, unit

From pg_settings

Where name like 'log%';

Michel SALAIS

De : still Learner <stilllearner23(at)gmail(dot)com <mailto:stilllearner23(at)gmail(dot)com> >
Envoyé : vendredi 18 juin 2021 11:03
À : pgsql-admin <pgsql-admin(at)postgresql(dot)org <mailto:pgsql-admin(at)postgresql(dot)org> >
Objet : STDERR not logging after a fix log size

Hi There,

A few days back (on 9th June) I have changed my log_rotation_size to 30 MB and on the same day again reset to 500 MB. for few days it went well, from 15th June itself generating only 30MB files. Now I have reset to 700 MB and reloaded, still am getting the same size of log and the log file is also not rotating.

I have tried changing the log_destination to Syslog which is logging in /var/log/messages however stderr not logging in to the log folder.

FYI ... please check below file stats and the log parameters.

postgres=# select version();
version
-----------------------------------------------------------------------------
PostgreSQL 11.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 5.5.0, 64-bit
(1 row)

ps -ef|grep logger
postgres 16765 16763 0 May15 ? 00:13:33 postgres: logger

-rw------- 1 postgres postgres 32885638 Jun 9 07:04 postgresql-2021-06-09_000000.log
-rw------- 1 postgres postgres 10765412 Jun 9 23:59 postgresql-2021-06-09_214301.log
-rw------- 1 postgres postgres 114219472 Jun 11 00:00 postgresql-2021-06-10_000000.log
-rw------- 1 postgres postgres 106193384 Jun 11 23:59 postgresql-2021-06-11_000000.log
-rw------- 1 postgres postgres 103008728 Jun 12 23:59 postgresql-2021-06-12_000000.log
-rw------- 1 postgres postgres 104213596 Jun 14 00:00 postgresql-2021-06-13_000000.log
-rw------- 1 postgres postgres 109578809 Jun 14 23:59 postgresql-2021-06-14_000000.log
-rw------- 1 postgres postgres 30847172 Jun 15 08:02 postgresql-2021-06-15_000000.log
-rw------- 1 postgres postgres 32452541 Jun 16 06:22 postgresql-2021-06-16_000000.log
-rw------- 1 postgres postgres 31439856 Jun 17 06:20 postgresql-2021-06-17_000000.log
-rw------- 1 postgres postgres 30859375 Jun 18 06:23 postgresql-2021-06-18_000000.log

log_autovacuum_min_duration 1s

log_destination stderr

log_directory log
log_error_verbosity default

log_file_mode 0600

log_filename postgresql-%Y-%m-%d_%H%M%S.log
log_line_prefix %t [%p]: [%h] [%l-1] user=%u,db=%d
log_min_duration_statement 2s
log_min_messages warning
log_rotation_age 1d

log_rotation_size 700MB

log_truncate_on_rotation off

logging_collector on

Please assist me if I had missed any.