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.
