Re: Correction of how to use TimeZone by ControlFile(xlog.c) - Mailing list pgsql-patches

From Gregory Stark
Subject Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Date
Msg-id 874pjgbq94.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Correction of how to use TimeZone by ControlFile(xlog.c)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Correction of how to use TimeZone by ControlFile(xlog.c)  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-patches
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Gregory Stark <stark@enterprisedb.com> writes:
>> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
>>> I don't think it's an acceptable change in either place.  People who
>>> want to see UTC in their logs can start the postmaster in UTC.  Those
>>> who are accustomed to seeing local time will squawk.
>
>> It would probably make sense to use UTC in the CSV logs since they're intended
>> to be machine readable. Whatever program is used to read them can handle
>> displaying the timestamps in the appropriate timezone for user's consumption.
>
> I don't think we really want to pay for formatting the timestamp twice
> (the existing patch goes out of its way to avoid that IIRC).

Well even if we include the time in integer seconds-since-unix-epoch format it
would be useful for a CSV data format.


--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Next
From: "Hiroshi Saito"
Date:
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)