Re: now() time off - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: now() time off
Date
Msg-id 20060223222119.GE2068@pervasive.com
Whole thread Raw
In response to Re: now() time off  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: now() time off
List pgsql-general
On Thu, Feb 23, 2006 at 12:41:38PM +0100, Martijn van Oosterhout wrote:
> On Wed, Feb 22, 2006 at 06:35:55PM -0600, Jim C. Nasby wrote:
> > On Wed, Feb 22, 2006 at 04:46:35PM -0600, Scott Marlowe wrote:
> > > Sounds like a time zone issue.  I'd start looking there.
> >
> > I've been bitten by this before as well. I'd be in favor of adding an
> > option such that postmaster would refuse to start if TZ was something
> > other than UTC; I'd much rather that then have a bunch of data get
> > screwed up...
>
> Alternativly you could just set the "timezone" parameter in the
> postgresql configuration...

Wow, didn't know that was there... was it added fairly recently or have
I just been blind?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How I changed the encoding of template1 after the fact
Next
From: Michael Fuhr
Date:
Subject: Re: ExclusiveLock without a relation in pg_locks