I have configured the following settings in PostgreSQL 13 on Windows.
logging_collector = on
log_rotation_size='100MB'
log_truncate_on_rotation = on
log_filename ='postgresql-%Y-%m-%d.log'
I have configured PostgreSQL to create a daily log. Is it possible for PostgreSQL to create another file (with the configured file name) and rename the existing file by appending with a different file name when the file reaches its configured log_rotation_size?
Do I have to run some script or services on the background so that the program is able to monitor the data/logs folder and rename the file when the log file size reaches the limit?