public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Peter Eisentraut <[email protected]>
Cc: Josh Berkus <[email protected]>
Cc: [email protected]
Subject: Re: Add strftime escapes to Log config
Date: Mon, 5 Sep 2011 22:58:57 -0400 (EDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
Peter Eisentraut wrote:
> 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.
Agreed. I have applied the attached patch to 9.1 and head.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Attachments:
[text/x-diff] /rtmp/strftime (849B, 2-%2Frtmp%2Fstrftime)
download | inline diff:
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
new file mode 100644
index 4b35169..615b2b0
*** a/doc/src/sgml/config.sgml
--- b/doc/src/sgml/config.sgml
*************** local0.* /var/log/postgresql
*** 3086,3091 ****
--- 3086,3095 ----
any time-zone-dependent <literal>%</literal>-escapes, the computation
is done in the zone specified
by <xref linkend="guc-log-timezone">.)
+ The supported <literal>%</literal>-escapes are similar to those
+ listed in the Open Group's <ulink
+ url="http://pubs.opengroup.org/onlinepubs/009695399/functions/strftime.html">strftime
+ </ulink> specification.
Note that the system's <systemitem>strftime</systemitem> is not used
directly, so platform-specific (nonstandard) extensions do not work.
</para>
view thread (5+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Add strftime escapes to Log config
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox