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> 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>
> *Envoyé :* vendredi 18 juin 2021 11:03
> *À :* pgsql-admin <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.
>
>
>