Re: [GENERAL] now() time off

2006-02-23 Thread Jim C. Nasby
On Thu, Feb 23, 2006 at 03:49:50PM -0700, Michael Fuhr wrote: > On Thu, Feb 23, 2006 at 04:21:19PM -0600, Jim C. Nasby wrote: > > On Thu, Feb 23, 2006 at 12:41:38PM +0100, Martijn van Oosterhout wrote: > > > Alternativly you could just set the "timezone" parameter in the > > > postgresql configurat

Re: [GENERAL] now() time off

2006-02-23 Thread Michael Fuhr
On Thu, Feb 23, 2006 at 04:21:19PM -0600, Jim C. Nasby wrote: > On Thu, Feb 23, 2006 at 12:41:38PM +0100, Martijn van Oosterhout wrote: > > Alternativly you could just set the "timezone" parameter in the > > postgresql configuration... > > Wow, didn't know that was there... was it added fairly rec

Re: [GENERAL] now() time off

2006-02-23 Thread Jim C. Nasby
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

Re: [GENERAL] now() time off

2006-02-23 Thread Martijn van Oosterhout
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

Re: [GENERAL] now() time off

2006-02-22 Thread Jim C. Nasby
On Wed, Feb 22, 2006 at 04:46:35PM -0600, Scott Marlowe wrote: > On Wed, 2006-02-22 at 16:36, John McCawley wrote: > > Earlier this week when I logged into my database, I just so happened to > > notice that the value for now() was six hours off of the time reported > > by the operating system whe

Re: [GENERAL] now() time off

2006-02-22 Thread Scott Marlowe
On Wed, 2006-02-22 at 16:36, John McCawley wrote: > Earlier this week when I logged into my database, I just so happened to > notice that the value for now() was six hours off of the time reported > by the operating system when using the date command from the command > line. How is this possibl

[GENERAL] now() time off

2006-02-22 Thread John McCawley
Earlier this week when I logged into my database, I just so happened to notice that the value for now() was six hours off of the time reported by the operating system when using the date command from the command line. How is this possible? I rebooted the server and the problem magically went