Re: Logfile purge

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Dec 18, 2014 at 10:39 AM, <shyamkant.dhamke@xxxxxxxxx> 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@xxxxxxxxxxxxxx

http://www.shreeyansh.com



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux