Thanks for the logrotate. Will try the linux logrotate utiliy.
Regards,
Amit
On Wed, Aug 18, 2010 at 4:13 PM, Thom Brown <thom@linux.com> wrote:
On 18 August 2010 11:34, Amit Soni <get.amitsoni@gmail.com> wrote: > Sorry for not stating this earlier. It's possible for me to have ~20GB of > logs in one day. So, per day rotation is not the best option here. And since > limiting the size of the file is only possible when we use some time related > pattern in the filename (which I should have deduced from > "log_truncate_on_rotation" not working on the size driven rotation), I see > the chances of getting what I need as very slim. > Any other suggestion would be greatly appreciated. > Thanks & Regards, > Amit >
Just change it so that it wraps after an hour then:
log_filename to "postgresql-%M.log" log_rotation_age to 1
log_rotation_size to 0
log_truncate_on_rotation to on
Or just go back to "postgresql.log" and use a separate log rotator to do the task for you, like logrotate.
