STDERR not logging after a fix log size

From: still Learner <stilllearner23(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: STDERR not logging after a fix log size
Date: 2021-06-18 09:02:45
Message-ID: CAB3gP9+RQ3EdBCnW6JCmGL6vh+SnkD0kQwuD8pvLTE7ogEpZfw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2021-06-18 10:44:15 Re: STDERR not logging after a fix log size
Previous Message Stephen Frost 2021-06-17 16:30:48 Re: compression in replication