Re: Log Rotation

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
>