The default timezone is being shown as UCT instead of UTC - Mailing list pgsql-bugs

From Kumar Harsh
Subject The default timezone is being shown as UCT instead of UTC
Date
Msg-id CAM8Q7gPjK+ePM0FBQP=wLZp4RsK1JEJmA9ZaFm4peyfB58yVCQ@mail.gmail.com
Whole thread Raw
List 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:

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

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15832: COPY into a partitioned table breaks its indexes
Next
From: Ashutosh Sharma
Date:
Subject: Re: BUG #15832: COPY into a partitioned table breaks its indexes