PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15547
PG Version9.6.1
OSCentOS 7
Opened2018-12-12 00:07:09+00
Reported byMatteo Bignotti
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15547
Logged by:          Matteo Bignotti
Email address:      (redacted)
PostgreSQL version: 9.6.1
Operating system:   CentOS 7
Description:        

I have a bunch of servers that never restarted in the past couple of months
and had postgres running since before Nov. 4th and I discovered that their
default timezone changed in the background.

‚óŹ postgresql.service - PostgreSQL database server
[...]
   Active: active (running) since Tue 2018-10-23 15:52:42 PDT; 1 months 18
days ago

in postgresql.conf the value of timezone and log_timezone is set to
"localtime" and I have a symlink in /usr/share/zoneinfo/ that points at the
timezone I want (also I know that's how Debian handles it). This works fine,
always, except in this situation I cannot seem to reproduce in any way. A
simple restart of postgres fixes the situation, but that's not what I wanted
to do.

I run these queries on 2 different servers in the America/Los_Angeles
timezone: psql [credentials] -c "SELECT now();" -c "show timezone;" -c
"SELECT timezone('UTC', now()) as UTC"

[no bug]
              now
-------------------------------
 2018-12-11 16:02:11.783056-08
(1 row)
 TimeZone
-----------
 localtime
(1 row)
            utc
----------------------------
 2018-12-12 00:02:11.823465
(1 row)

[with bug]
              now
-------------------------------
 2018-12-12 00:03:30.970079+00
(1 row)
 TimeZone
-----------
 localtime
(1 row)
            utc
----------------------------
 2018-12-12 00:03:30.971193
(1 row)

I really blame this situation on DST simply because that's the only thing
that happened in this timeframe that could've caused a timezone "flop".

both servers point to America/Los_Angeles and this server "with bug" is the
last one I have that exhibits, all my attempts at reproducing this have been
in vain.

Thank you

Messages

DateAuthorSubject
2018-12-12 00:07:09+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15547: default timezone on servers running while time changed from PDT to PST reverting to UTC.
2018-12-12 00:46:44+00Tom LaneRe: BUG #15547: default timezone on servers running while time changed from PDT to PST reverting to UTC.
2018-12-12 01:35:55+00MatteoFwd: BUG #15547: default timezone on servers running while time changed from PDT to PST reverting to UTC.
2018-12-12 14:38:27+00Tom LaneRe: Fwd: BUG #15547: default timezone on servers running while time changed from PDT to PST reverting to UTC.
2018-12-12 20:44:55+00MatteoRe: Fwd: BUG #15547: default timezone on servers running while time changed from PDT to PST reverting to UTC.