Re: log_filename_prefix --> log_filename + strftime()

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Subject: Re: log_filename_prefix --> log_filename + strftime()
Date: 2004-09-20 22:49:38
Message-ID: 200409201649.38715.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Monday September 20 2004 4:43, Ed L. wrote:
>
> This patch rotates logs on local time boundaries instead of UTC
> boundaries, e.g., midnight local for daily rotation instead of midnight
> UTC. It does so by parsing the "%z" result from strftime().
>
> ... I am arguing for
> inclusion of this patch because 1) the utility of local time boundary
> rotations exceeds the risk for us, and because 2) the risk can be
> mitigated by a comment in the documentation and maybe postgresql.conf,
> and because 3) I think the issue already exists and this doesn't make it
> worse.

And I'd add that working with UTC-oriented rotations in 8.0.0 beta code has
already proved annoying and needlessly confusing, thus the patch. Daily
log rotations occur at 18:00 here.

Ed

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-09-20 22:57:01 Re: log_filename_prefix --> log_filename + strftime()
Previous Message Ed L. 2004-09-20 22:43:51 Re: log_filename_prefix --> log_filename + strftime()