Re: Log Rotation

Thanks for the response guys, yeah that works with the specific log file.
Have a nice day!

sagar jadhav <sagarjdhv5(at)gmail(dot)com>, 13 Ara 2023 Çar, 05:13 tarihinde şunu
yazdı:

> Hi,
> You can set "log_truncate_on_rotation" to "on" to truncate the log files
> if the log file name is same on rotation.
>
> Thanks,
> Sagar
>
> On Tue, Dec 12, 2023 at 9:41 PM SOzcn <selahattinozcnma(at)gmail(dot)com> wrote:
>
>> 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
>>
>