Log Rotation

From: SOzcn <selahattinozcnma(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Log Rotation
Date: 2023-12-12 16:11:12
Message-ID: CAJyV5AbCRUdGE0TbdXJ02wfRGwq7uLd1UmmE-GE8nqqUf4U-Zw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello team I hope everything going well for you guys!

I have a question about log rotation.

I set the parameters as a daily. The set parameters are as follows.

In this case, the log file is created as
"postgresqllogtest-2023-12-12_182351.log" after the 13th day file, the logs
in the 12th day file need to be truncated.

Is the expected result correct? Or does PostgreSQL not support deleting,
truncating files? I got successful results when I did this process hourly.
However, I could not get a correct result when I tried it daily log
truncate.

The parameter for I used as Hour log; postgresql-%H%M

log_destination = 'stderr'
logging_collector = on
log_directory = '/var/log/postgresql/logtest'
log_filename = 'postgresqllogtest-%Y-%m-%d_%H%M%S.log'
log_rotation_age=1440
log_min_duration_statement = 5000
log_line_prefix = 'time=%t [%p]: db=%d,user=%u,app=%a,client=%h '
log_statement = 'none'
log_temp_files = 0
log_timezone = 'Europe/Istanbul'
log_hostname = on
log_min_messages = warning
log_min_error_statement = error
log_lock_waits = on

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2023-12-12 16:18:02 Re: Log Rotation
Previous Message Roland Che 2023-12-11 10:04:17 pg_auto_failover issues with password auth