Skip site navigation (1) Skip section navigation (2)

Re: Correction of how to use TimeZone by ControlFile(xlog.c)

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Gregory Stark" <stark(at)enterprisedb(dot)com>,"Magnus Hagander" <magnus(at)hagander(dot)net>,"Andrew Dunstan" <andrew(at)dunslane(dot)net>,<pgsql-patches(at)postgresql(dot)org>
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Date: 2007-08-03 16:32:08
Message-ID: 00e001c7d5eb$d5f5b8f0$01324d80@hiroshi5jz7dqj (view raw or flat)
Thread:
Lists: pgsql-patches
> "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> writes:
>> I understand the essence which you say. Then, I think that gmtime is an ideal 
>> there. localtime also takes summer time into consideration. It changes and 
>> sometimes falls unconsciously. Furthermore, a tzname can't be expressed 
>> by the present elog....
>> Moreover, how about relocating datacenter to New York from the loss Angelus?
>> The log is continued.... database log is an audit item. Recently, it is more 
>> important than a response. And it is used secondarily.
> 
> People who find the above arguments compelling would certainly be free
> to set their log_timezone to GMT.  Those who don't find them compelling
> should not be forced to deal in GMT.  The fact that Postgres has always
> logged in system local time, and we've had no complaints about that,
> suggests to me that most people prefer local-time logging.

A certain user said. timezone of GUC is not effective with an elog output.....
I am, though it is an ideal that there is (e)log_timezone which you say.:-)
Um, I think that only for PostgreSQL is good.

BTW, windows user should do how.?

Regards,
Hiroshi Saito


In response to

pgsql-patches by date

Next:From: Andrew DunstanDate: 2007-08-03 17:00:18
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Previous:From: Tom LaneDate: 2007-08-03 15:33:15
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group