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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461