Thread: PG 8.1 log rotation

PG 8.1 log rotation

From
"Chris Hoover"
Date:
Question, 

Can you set both the log_rotation_age and log_rotation_size?  If so, does either one have presidence over the other?  I would like to have both on and am hoping that you will tell me that they work together.

So, if log_rotation_age = 1440, and log_rotation_size = 1048576 then my log will be rotated each time the log hits 1GB and also at the end of the day.

Thanks,

Chris

Re: PG 8.1 log rotation

From
Tom Lane
Date:
"Chris Hoover" <revoohc@gmail.com> writes:
> Can you set both the log_rotation_age and log_rotation_size?

Sure.  It'll rotate whenever either limit is reached.

            regards, tom lane