Message-ID: <4D866471.30609@agliodbs.com>
Date: Sun, 20 Mar 2011 13:32:49 -0700
From: Josh Berkus <josh@agliodbs.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
	rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2
MIME-Version: 1.0
To: pgsql-docs@postgreSQL.org
Subject: Add strftime escapes to Log config
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

All,

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.


-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com