The default timezone is being shown as UCT instead of UTC

From: Kumar Harsh <khs(at)playlyfe(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: The default timezone is being shown as UCT instead of UTC
Date: 2019-06-04 08:37:06
Message-ID: CAM8Q7gPjK+ePM0FBQP=wLZp4RsK1JEJmA9ZaFm4peyfB58yVCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Package: postgresql-11
Version: 11.3.1

The postgres system has the default timezone set to 'UCT'
instead of 'UTC'. This bug was introduced in version 9.6.12,
and hasn't been fixed as of the latest stable version (11.3.1).

Reproducible example:

Run psql, and then:

psql (11.3 (Debian 11.3-1.pgdg90+1))

Type "help" for help.

postgres=# show timezone;
show timezone;
-[ RECORD 1 ]-
TimeZone | UCT

This issue was originally reported already in the
Github docker repository here:
https://github.com/docker-library/postgres/issues/577

I suggest that the default timezone be made 'UTC' like it was
before (and like is expected).

I am running the postgres server insider a docker container
on Windows Subsystem for Linux, but this happens in other
pure debian linux systems too.
*Please see the Github issue linked above for more details.*

Regards
Harsh

Browse pgsql-bugs by date

  From Date Subject
Next Message Ashutosh Sharma 2019-06-04 09:19:48 Re: BUG #15832: COPY into a partitioned table breaks its indexes
Previous Message PG Bug reporting form 2019-06-04 04:41:55 BUG #15832: COPY into a partitioned table breaks its indexes