"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