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

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

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>, "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 17:51:31
Message-ID: 1207A228-F594-46D1-A23E-2A979AAC17F9@seespotcode.net (view raw or flat)
Thread:
Lists: pgsql-patches
On Aug 3, 2007, at 10:33 , Tom Lane wrote:

> 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.

I've most likely missed something as I'm unfamiliar with this area,  
but would it make sense to record the time zone offset? Then whether  
its in local time or UTC, it's always marking a unique instant in time.

Michael Glaesemann
grzm seespotcode net



In response to

pgsql-patches by date

Next:From: Gregory StarkDate: 2007-08-03 17:52:13
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)
Previous:From: Tom LaneDate: 2007-08-03 17:04:48
Subject: Re: Correction of how to use TimeZone by ControlFile(xlog.c)

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