pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
config patch: Note changing timezone requires restart
3+ messages / 2 participants
[nested] [flat]

* config patch: Note changing timezone requires restart
@ 2011-03-10 02:16 Glen Barber <glen.j.barber@gmail.com>
  2011-03-10 18:19 ` Re: config patch: Note changing timezone requires restart Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Glen Barber @ 2011-03-10 02:16 UTC (permalink / raw)
  To: pgsql-testers

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

Attachments:

src.backend.utils.misc.postgresql.conf.sample.diff (text/x-diff, 578B) download diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index ed70223..20b4834 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -475,7 +475,7 @@ #datestyle = 'iso, mdy' #intervalstyle = 'postgres' #timezone = unknown # actually, defaults to TZ environment - # setting + # setting (change requires restart) #timezone_abbreviations = 'Default' # Select the set of available time zone # abbreviations. Currently, there are # Default
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: config patch: Note changing timezone requires restart
  2011-03-10 02:16 config patch: Note changing timezone requires restart Glen Barber <glen.j.barber@gmail.com>
@ 2011-03-10 18:19 ` Josh Berkus <josh@agliodbs.com>
  2011-03-11 21:39   ` Re: config patch: Note changing timezone requires restart Glen Barber <glen.j.barber@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Josh Berkus @ 2011-03-10 18:19 UTC (permalink / raw)
  To: Glen Barber <glen.j.barber@gmail.com>; +Cc: pgsql-testers

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: config patch: Note changing timezone requires restart
  2011-03-10 02:16 config patch: Note changing timezone requires restart Glen Barber <glen.j.barber@gmail.com>
  2011-03-10 18:19 ` Re: config patch: Note changing timezone requires restart Josh Berkus <josh@agliodbs.com>
@ 2011-03-11 21:39   ` Glen Barber <glen.j.barber@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Glen Barber @ 2011-03-11 21:39 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-testers

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2011-03-11 21:39 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-03-10 02:16 config patch: Note changing timezone requires restart Glen Barber <glen.j.barber@gmail.com>
2011-03-10 18:19 ` Josh Berkus <josh@agliodbs.com>
2011-03-11 21:39   ` Glen Barber <glen.j.barber@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox