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.