Subject: Re: Add strftime escapes to Log config
From: Peter Eisentraut <peter_e@gmx.net>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-docs@postgreSQL.org
In-Reply-To: <4D866471.30609@agliodbs.com>
References: <4D866471.30609@agliodbs.com>
Content-Type: text/plain; charset="UTF-8"
Date: Mon, 28 Mar 2011 21:48:30 +0300
Message-ID: <1301338110.17107.0.camel@vanquo.pezone.net>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

On sön, 2011-03-20 at 13:32 -0700, Josh Berkus wrote:
> This page:
> 
> http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE
> 
> has the following text:
> 
> The value is treated as a strftime pattern, so %-escapes can be used to
> specify time-varying file names.
> 
> However, nowhere in our docs do we list sample strftime escapes.  This
> means that PG DBAs who are not programmers (and even some who are) end
> up googling for them all the time.  So I would like to add the following
> text:
> 
> Useful excape codes which are available on most platforms include: %Y =
> year, %m = month, %d = day of month, %H = hour, %M = minute, %a = short
> weekday name, and %b = short month name.

We could also link to
<http://pubs.opengroup.org/onlinepubs/007908799/xsh/strftime.html>, for
example.