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.

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.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to