Tom Lane wrote:
That struck me as not only useless but the deliberately hard way to do it. To use that in the real world, you'd have to set up a cron job to trigger the rotation,
Still on my radar...
which means a lot of infrastructure and privilege;
whereas ISTM the point of this feature was to avoid both.
... I was thinking about putting this into the pg_autovacuum process.
The log
capture process should just do its own rotation on a pre-configured
time-interval basis, and/or maximum-file-size basis.
Yup.
I see zero value
added in having it respond to external signals.
I see >0 value. I like to truncate my logfile before doing some complicated stuff, to have a handy file for debugging purposes.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings