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
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 |