X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8889AD86F2 for ; Tue, 13 Sep 2005 11:44:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83566-02 for ; Tue, 13 Sep 2005 14:44:02 +0000 (GMT) Received: from TWMAIL.ESNCC.COM (static-66-173-159-28.t1.cavtel.net [66.173.159.28]) by svr1.postgresql.org (Postfix) with ESMTP id 1174CD862D for ; Tue, 13 Sep 2005 11:43:59 -0300 (ADT) Received: from spawar2i8uvlb9 ([150.125.117.63]) by TWMAIL.ESNCC.COM with Microsoft SMTPSVC(5.0.2195.6713); Tue, 13 Sep 2005 10:44:11 -0400 From: "Lane Van Ingen" To: "Tom Lane" Cc: Subject: Re: Server Time Setting Date: Tue, 13 Sep 2005 10:47:37 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <6275.1126564924@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Importance: Normal X-OriginalArrivalTime: 13 Sep 2005 14:44:11.0951 (UTC) FILETIME=[9AE60BF0:01C5B871] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.064 required=5 tests=[AWL=0.014, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/133 X-Sequence-Number: 18870 -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Monday, September 12, 2005 6:42 PM To: Lane Van Ingen Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Server Time Setting "Lane Van Ingen" writes: >> I am baffled as to why some of the PostgreSQL functions (like now() ) are >> returning >> a time which is exactly an hour later than the server's actual system time. > I'd say you've got TimeZone set to something different than you think > you do. > regards, tom lane Before I asked this question yesterday, I had already checked SHOW ALL and found only two PostgreSQL config parameters that seemed to apply, and they were set properly: australian_timezones = no TimeZone = US/Eastern We are running 8.0.1, Windows 2003. Since last message, checked 3 other servers, and found that I have the same problem on two out of three: Server #1: select now() agreed with Windows time on this one Server #2: select now() was exactly one hour greater than Windows time where config parms were set the same as previous paragraph Server #3: select now() was exactly one hour greater than Windows time, but config parm was set wrong: TimeZone = Europe/Dublin (don't know how that happened but makes you wonder if TimeZone has anything to do with this at all!) Windows 2003 time was set correctly in all four cases. Summary: - one server displays time correctly - two servers APPEAR to be set correctly, but time displayed from now() as one hour greater than Windows time - one server is set incorrectly, but TimeZone did not appear to have any effect on the time being displayed; now() just displayed time as one hour greater than Windows time Being as one server is 'doing it right', there must be some difference, but so far I have not found what is different.