Hello Tom, Thanks for the response. On the top you can see the parameters, I already set the parameters as you said. But the truncate didn't work for daily.
Tom Lane <tgl@sss.pgh.pa.us>, 12 Ara 2023 Sal, 19:18 tarihinde şunu yazdı:
SOzcn <selahattinozcnma@gmail.com> writes: > 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.
If you want log rotation, you need to choose your filename pattern so that old log files will be overwritten after a while; or else set up some external tool for removing the old ones. Postgres does not do anything to keep track of old log files.