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 1D90BD8C2E for ; Mon, 12 Sep 2005 18:03:03 -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 95467-06 for ; Mon, 12 Sep 2005 21:02:59 +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 7C63BD8BF7 for ; Mon, 12 Sep 2005 18:02:59 -0300 (ADT) Received: from spawar2i8uvlb9 ([150.125.117.63]) by TWMAIL.ESNCC.COM with Microsoft SMTPSVC(5.0.2195.6713); Mon, 12 Sep 2005 17:03:04 -0400 From: "Lane Van Ingen" To: Subject: Re: Server Time Setting Date: Mon, 12 Sep 2005 17:06:35 -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) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Importance: Normal In-Reply-To: X-OriginalArrivalTime: 12 Sep 2005 21:03:04.0763 (UTC) FILETIME=[5E4C20B0:01C5B7DD] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.065 required=5 tests=[AWL=0.015, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/113 X-Sequence-Number: 18850 Forgot to mention, I am using version 8.0.1 on Windows 2003 ... -----Original Message----- From: Lane Van Ingen [mailto:lvaningen@esncc.com] Sent: Monday, September 12, 2005 5:05 PM To: pgsql-admin@postgresql.org Subject: Server Time Setting 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 have checked PostgreSQL config parms by doing a SHOW ALL and search the manual for anything else that might be related, yet everything looks fine to me. Does anybody know why this would be?