Re: Empty ./share/timezone/UTC and failure to set UTC as timezone

Sasa Vilic <sasavilic@gmail.com> writes:
> To double check, I took official 9.6.7 sources, compiled and installed it
> locally (/tmp/pgsql) and tried connecting with client again and I again we
> got same error message.

Hm, what platform and compiler are you using, exactly?

> In order to further investigate this, I have attached strace on backend and
> I have noticed that PG is able to find and read file ./share/timezone/UTC.
> But right after reading the file, we get error message from above.
> We noticed that UTC file is empty! Is this on purpose or is this is bug? Am
> I missing something?

It should certainly not be empty.  On my machine it's 127 bytes long:

$ ls -l share/timezone/UTC
-rw-r--r--. 6 postgres postgres 127 Feb 19 12:27 share/timezone/UTC

and file(1) knows what it is:

$ file share/timezone/UTC
share/timezone/UTC: timezone data, version 2, 1 gmt time flag, 1 std time flag, no leap seconds, no transition times, 1
abbreviationchar 

I wonder if you've tripped over some portability issue in the zic
compiler.  Another idea, seeing that this file is multiply-linked
in the timezone install tree, is that maybe you're on a filesystem
that does strange things with hard links.

It'd be interesting to see the rest of your timezone directory.  Mine
looks like

total 248
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Africa
drwxr-xr-x.  6 postgres postgres 4096 Feb 19 12:27 America
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Antarctica
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Arctic
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Asia
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Atlantic
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Australia
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Brazil
-rw-r--r--.  1 postgres postgres 2102 Feb 19 12:27 CET
-rw-r--r--.  1 postgres postgres 2294 Feb 19 12:27 CST6CDT
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Canada
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Chile
-rw-r--r--.  2 postgres postgres 2437 Feb 19 12:27 Cuba
-rw-r--r--.  1 postgres postgres 1876 Feb 19 12:27 EET
-rw-r--r--.  1 postgres postgres  127 Feb 19 12:27 EST
-rw-r--r--.  1 postgres postgres 2294 Feb 19 12:27 EST5EDT
-rw-r--r--.  2 postgres postgres 1972 Feb 19 12:27 Egypt
-rw-r--r--.  2 postgres postgres 3543 Feb 19 12:27 Eire
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Etc
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Europe
-rw-r--r--.  1 postgres postgres  148 Feb 19 12:27 Factory
-rw-r--r--.  7 postgres postgres 3687 Feb 19 12:27 GB
-rw-r--r--.  7 postgres postgres 3687 Feb 19 12:27 GB-Eire
-rw-r--r--. 10 postgres postgres  127 Feb 19 12:27 GMT
-rw-r--r--. 10 postgres postgres  127 Feb 19 12:27 GMT+0
-rw-r--r--. 10 postgres postgres  127 Feb 19 12:27 GMT-0
-rw-r--r--. 10 postgres postgres  127 Feb 19 12:27 GMT0
-rw-r--r--. 10 postgres postgres  127 Feb 19 12:27 Greenwich
-rw-r--r--.  1 postgres postgres  128 Feb 19 12:27 HST
-rw-r--r--.  2 postgres postgres 1189 Feb 19 12:27 Hongkong
-rw-r--r--.  2 postgres postgres 1188 Feb 19 12:27 Iceland
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Indian
-rw-r--r--.  2 postgres postgres 1718 Feb 19 12:27 Iran
-rw-r--r--.  3 postgres postgres 2265 Feb 19 12:27 Israel
-rw-r--r--.  2 postgres postgres  507 Feb 19 12:27 Jamaica
-rw-r--r--.  2 postgres postgres  318 Feb 19 12:27 Japan
-rw-r--r--.  2 postgres postgres  259 Feb 19 12:27 Kwajalein
-rw-r--r--.  2 postgres postgres  655 Feb 19 12:27 Libya
-rw-r--r--.  1 postgres postgres 2102 Feb 19 12:27 MET
-rw-r--r--.  1 postgres postgres  127 Feb 19 12:27 MST
-rw-r--r--.  1 postgres postgres 2294 Feb 19 12:27 MST7MDT
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Mexico
-rw-r--r--.  4 postgres postgres 2460 Feb 19 12:27 NZ
-rw-r--r--.  2 postgres postgres 2087 Feb 19 12:27 NZ-CHAT
-rw-r--r--.  4 postgres postgres 2453 Feb 19 12:27 Navajo
-rw-r--r--.  5 postgres postgres  414 Feb 19 12:27 PRC
-rw-r--r--.  1 postgres postgres 2294 Feb 19 12:27 PST8PDT
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 Pacific
-rw-r--r--.  2 postgres postgres 2705 Feb 19 12:27 Poland
-rw-r--r--.  2 postgres postgres 3453 Feb 19 12:27 Portugal
-rw-r--r--.  2 postgres postgres  790 Feb 19 12:27 ROC
-rw-r--r--.  2 postgres postgres  531 Feb 19 12:27 ROK
-rw-r--r--.  2 postgres postgres  424 Feb 19 12:27 Singapore
-rw-r--r--.  3 postgres postgres 2166 Feb 19 12:27 Turkey
-rw-r--r--.  2 postgres postgres  127 Feb 19 12:27 UCT
drwxr-xr-x.  2 postgres postgres 4096 Feb 19 12:27 US
-rw-r--r--.  6 postgres postgres  127 Feb 19 12:27 UTC
-rw-r--r--.  6 postgres postgres  127 Feb 19 12:27 Universal
-rw-r--r--.  2 postgres postgres 1544 Feb 19 12:27 W-SU
-rw-r--r--.  1 postgres postgres 1873 Feb 19 12:27 WET
-rw-r--r--.  6 postgres postgres  127 Feb 19 12:27 Zulu
-rw-r--r--.  3 postgres postgres 3545 Feb 19 12:27 posixrules

            regards, tom lane