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,
