Re: Log Rotation

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Log Rotation
Дата
Msg-id CANzqJaDz_wtxAJbWK0m7HYDxf24NDfcVZuEWU050=e5-rwvrMA@mail.gmail.com
обсуждение исходный текст
Ответ на Log Rotation  (SOzcn <selahattinozcnma@gmail.com>)
Ответы Re: Log Rotation  (SOzcn <selahattinozcnma@gmail.com>)
Список pgsql-admin
On Tue, Dec 12, 2023 at 11:11 AM SOzcn <selahattinozcnma@gmail.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).

В списке pgsql-admin по дате отправления:

Предыдущее
От: SOzcn
Дата:
Сообщение: Re: Log Rotation
Следующее
От: SOzcn
Дата:
Сообщение: Re: Log Rotation