Обсуждение: config patch: Note changing timezone requires restart

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.

I've attached a diff of the default config which notes this.

Best regards,

--
Glen Barber

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

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