Re: Fwd: BUG #15547: default timezone on servers running while time changed from PDT to PST reverting to UTC. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Fwd: BUG #15547: default timezone on servers running while time changed from PDT to PST reverting to UTC.
Date
Msg-id 11284.1544625507@sss.pgh.pa.us
Whole thread Raw
In response to Fwd: BUG #15547: default timezone on servers running while timechanged from PDT to PST reverting to UTC.  (Matteo <gugoll@gmail.com>)
Responses Re: Fwd: BUG #15547: default timezone on servers running while timechanged from PDT to PST reverting to UTC.  (Matteo <gugoll@gmail.com>)
List pgsql-bugs
Matteo <gugoll@gmail.com> writes:
> I thought the same thing about tzdata but I didn't update that on any
> servers in that timeframe, the servers are only updated manually and the
> only package that I added was "psmisc-22.20-15.el7.x86_64" on Nov 14th.

Hm.  Just to clarify: do you believe that the servers with the wrong
timezone behavior actually changed behavior sometime after being started?
It'd be way easier to believe that they'd been wrong since postmaster
start.  Also, do you have the postmaster logs going back to startup?
It'd be interesting to check for possible error/warning messages at
postmaster start, and/or whenever the behavior changed.

            regards, tom lane


pgsql-bugs by date:

Previous
From: Matteo
Date:
Subject: Fwd: BUG #15547: default timezone on servers running while timechanged from PDT to PST reverting to UTC.
Next
From: Bezverhijs Eduards
Date:
Subject: segmentation fault with simple UPDATE statement (postgres 10.5)