Re: serverlog rotation/functions - Mailing list pgsql-patches

From Andreas Pflug
Subject Re: serverlog rotation/functions
Date
Msg-id 40F54B62.7050409@pse-consulting.de
Whole thread Raw
In response to Re: serverlog rotation/functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: PITR Archive Recovery plus WIP PITR
Next
From: Peter Eisentraut
Date:
Subject: Re: build infrastructure for extensions v3