Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0B2241337B97 for ; Thu, 10 Mar 2011 14:19:59 -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 20338-06 for ; Thu, 10 Mar 2011 18:19:51 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148147.authsmtp.net (outmail148147.authsmtp.net [62.13.148.147]) by mail.postgresql.org (Postfix) with ESMTP id 32543133655C for ; Thu, 10 Mar 2011 14:19:50 -0400 (AST) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt12.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p2AIJlEc043971; Thu, 10 Mar 2011 18:19:47 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p2AIJhQG062441; Thu, 10 Mar 2011 18:19:44 GMT Message-ID: <4D791634.5090608@agliodbs.com> Date: Thu, 10 Mar 2011 10:19:32 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: Glen Barber CC: pgsql-testers@postgresql.org Subject: Re: config patch: Note changing timezone requires restart References: <4D78348C.3040108@gmail.com> In-Reply-To: <4D78348C.3040108@gmail.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: f99e2dfc-4b42-11e0-80b9-0022640b883e X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1ADdh12OUdbHwkA AnYKU15VWVd1XS1z bxRZbBtfZk9QXgRr T0pMQFdNFEsoA214 fEZ/JRl0dQFCeTBy ZkZgECZSVRF4IRAu X0oGEW8bZGY1aH0X UBJRagNUcgFMeh8X Ylh8AT1vNG8XDR4V JDMeBQsEdT5YLipU TUkVJE4ZQRRDODkg SlgJHTwpEkwDSG0v LhkrOFkaEQ4LP1wv MEEsQhoCPgQOAxdC dwAA X-Authentic-SMTP: 61633136333939.1015:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201103/2 X-Sequence-Number: 215 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? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com