Sasa Vilic <sasavilic@xxxxxxxxx> 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 abbreviation char 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
