Re: Log Rotation

On Tue, Dec 12, 2023 at 11:11 AM 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'
>

%M%S really isn't needed.

> log_rotation_age=1440
>

(Setting that to "1d" is clearer IMO than 1440 minutes.)

It _says_ "rotation", but _means_ "overwrite".

If you want to _delete_ files older than 12 days, you must have an external
process do it: logrotate, or your own shell script that uses find(1).
https://unix.stackexchange.com/questions/459996/deleting-older-log-files