Re: Logfile purge
| От | Harshad Adalkonda |
|---|---|
| Тема | Re: Logfile purge |
| Дата | |
| Msg-id | CANnQH_i-ozUiw08UM__79hUmfcO-SAiHcfbhNBAC6rE5AkjcSQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Logfile purge (<shyamkant.dhamke@wipro.com>) |
| Список | pgsql-admin |
On Thu, Dec 18, 2014 at 10:39 AM, <shyamkant.dhamke@wipro.com> wrote:
Hi,
I need help on PostGres 9.2 version. How to purge the logfile generated by the postgres server? How I can restrict the size of this file?
Regards
Shyamkant
Hi Shyamkant,
If you want purge the log file you set log_truncate_on_rotation=on in postgresql.conf
but this log_truncate_on_rotation works on time-drivan basic not on size, so you need to also specify log_rotation_age=1d .
You can restrict the size with log_rotation_size=10MB , but after 10MB it will create new file of 10MB again.
You can't use both the log_truncate_on_rotation & log_rotation_size at same time.
Thanks & Regards,
Harshad Adalkonda
Database Administrator
harshad.adalkonda@shreeyansh.com
В списке pgsql-admin по дате отправления: