Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8B1A11337B61 for ; Fri, 11 Mar 2011 17:40:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 41710-07 for ; Fri, 11 Mar 2011 21:39:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id 33C2F1337B49 for ; Fri, 11 Mar 2011 17:39:53 -0400 (AST) Received: by vxi39 with SMTP id 39so2993122vxi.19 for ; Fri, 11 Mar 2011 13:39:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:message-id:date:from:user-agent:mime-version:to :cc:subject:references:in-reply-to:x-enigmail-version:content-type :content-transfer-encoding; bh=TV9pZfo70HyYp+vJ26RTDihCJe5bGYX3p9Ga1P8JlPw=; b=Ln/Fkf3lElTQRUdJYmwW/pI/5FxFmpiTmlDkxNoyGUY+UFgFC2H7ywzGgHlW5Di7in Xgcy2by/pyLH+xBjvTD8Zj34J8lz9iMmK85A5W4TIMS/5wTh3ZqafREUF9I7+kMeRaIg ii1lieOLMrm8sg9qNGO1molDQh1lZmjXMi+Gk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:x-enigmail-version:content-type :content-transfer-encoding; b=mBpIUinTDDxDcmr3uwZO4dDm/lshIvdpTa/a3h59VKBweUmqYpqQPGzUG9I1/NCEMO NdYVsZesFcOgRwgwb7Jo7oTXBpU+bAYtomQnzr06OYqWMmaqPn6EBNACjkOur/WWAo+8 6tMdqgixQTCZmyEa4EZJO+Vnpufvp809Xwhx4= Received: by 10.52.71.243 with SMTP id y19mr14189063vdu.191.1299879592017; Fri, 11 Mar 2011 13:39:52 -0800 (PST) Received: from schism.local (75-146-225-65-Philadelphia.hfc.comcastbusiness.net [75.146.225.65]) by mx.google.com with ESMTPS id u14sm1735206vcr.1.2011.03.11.13.39.49 (version=SSLv3 cipher=OTHER); Fri, 11 Mar 2011 13:39:49 -0800 (PST) Message-ID: <4D7A96A4.4060800@gmail.com> Date: Fri, 11 Mar 2011 16:39:48 -0500 From: Glen Barber User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9 MIME-Version: 1.0 To: Josh Berkus CC: pgsql-testers@postgresql.org Subject: Re: config patch: Note changing timezone requires restart References: <4D78348C.3040108@gmail.com> <4D791634.5090608@agliodbs.com> In-Reply-To: <4D791634.5090608@agliodbs.com> X-Enigmail-Version: 1.1.1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201103/3 X-Sequence-Number: 216 On 3/10/11 1:19 PM, Josh Berkus wrote: > On 3/9/11 6:16 PM, Glen Barber wrote: >> Hi, >> >> I'm not sure of the best place to submit this. I'm running 9.0.3 and >> noticed changing the timezone requires a server restart to take effect. > > TimeZone is just a default timezone for new sessions. The server itself > does not have a timezone. > > Mind you, a client connection default should change for new sessions > after a reload. Have you tested that it doesn't? > Hi Josh, It looks like I was looking down the wrong rabbit hole. Sorry for the noise. However, I am seeing odd behavior with clients setting timezone to 'UTC' that changed since 9.0.0 and 9.0.3. Superficially, it appears 9.0.3 isn't traversing /usr/share/zoneinfo properly to find Etc/UTC. I'll post to -general@ once I've verified it isn't pilot error. Best regards, -- Glen Barber