Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ero4S-0007tr-S7 for pgsql-admin@arkaria.postgresql.org; Fri, 02 Mar 2018 17:02:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ero4R-0002sl-Mc for pgsql-admin@arkaria.postgresql.org; Fri, 02 Mar 2018 17:02:11 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ero4R-0002sa-7K for pgsql-admin@lists.postgresql.org; Fri, 02 Mar 2018 17:02:11 +0000 Received: from colo1.denninger.net ([104.236.120.189]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ero4J-0006QM-Gj for pgsql-admin@postgresql.org; Fri, 02 Mar 2018 17:02:10 +0000 Received: from denninger.net (ip68-1-57-197.pn.at.cox.net [68.1.57.197]) by colo1.denninger.net (Postfix) with ESMTP id 790A421108C; Fri, 2 Mar 2018 12:01:01 -0500 (EST) Received: from [192.168.10.23] (D13.Denninger.Net [192.168.10.23]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by denninger.net (Postfix) with ESMTPSA id 81A843A018E; Fri, 2 Mar 2018 11:01:01 -0600 (CST) Subject: Re: Time zone issue with 10.3? To: Tom Lane Cc: pgsql-admin@postgresql.org References: <668c10b2-f4dc-7152-6a9e-e70c029e85e0@denninger.net> <30753.1520009899@sss.pgh.pa.us> From: Karl Denninger Message-ID: Date: Fri, 2 Mar 2018 11:01:01 -0600 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: <30753.1520009899@sss.pgh.pa.us> Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg=sha-512; boundary="------------ms000700060003000301070709" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a cryptographically signed message in MIME format. --------------ms000700060003000301070709 Content-Type: multipart/alternative; boundary="------------DC5D1CBC79031C64C52651B8" Content-Language: en-US This is a multi-part message in MIME format. --------------DC5D1CBC79031C64C52651B8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 3/2/2018 10:58, Tom Lane wrote: > Karl Denninger writes: >> I have just tried r0lling forward to 10.3 from 10.1 and suddenly my ti= me >> zone declaration blew up. >> I was using 'US/Chicago' and was able to get the server to start with >> CST6CDT, which is the way the system is set up.=C2=A0 But I'm concerne= d about >> this, because I now get this from trying to query the system tables fo= r >> timezone names: >> pgsql=3D# select * from pg_timezone_names; >> =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | abbrev | utc_off= set | is_dst >> --------------------------+--------+------------+-------- >> =C2=A0Canada/East-Saskatchewan | CST=C2=A0=C2=A0=C2=A0 | -06:00:00=C2=A0= | f >> (1 row) >> pgsql=3D# select * from pg_timezone_abbrevs; >> ERROR:=C2=A0 time zone "Asia/Yerevan" not recognized >> DETAIL:=C2=A0 This time zone name appears in the configuration file fo= r time >> zone abbreviation "amst". > Hmm, is your build configured with --with-system-tzdata > (pg_config --configure would tell you)? If so, is that pointing at > a reasonable-looking tree of TZ data? It seems you don't have the > TZ data correctly installed in the 10.3 installation, but it's hard > to tell who to blame from this much info. > > Typically the top of the TZ file tree should look like > > $ ls /usr/share/zoneinfo > Africa/ Canada/ GB Indian/ Mexico/ ROK iso316= 6.tab > America/ Chile/ GB-Eire Iran NZ Singapore leapse= conds > Antarctica/ Cuba GMT Israel NZ-CHAT Turkey posix/= > Arctic/ EET GMT+0 Jamaica Navajo UCT posixr= ules > Asia/ EST GMT-0 Japan PRC US/ right/= > Atlantic/ EST5EDT GMT0 Kwajalein PST8PDT UTC tzdata= =2Ezi > Australia/ Egypt Greenwich Libya Pacific/ Universal zone.t= ab > Brazil/ Eire HST MET Poland W-SU zone19= 70.tab > CET Etc/ Hongkong MST Portugal WET > CST6CDT Europe/ Iceland MST7MDT ROC Zulu > > If you're not trying to rely on a platform-provided installation > of tzdata, then this ought to be under the share/ subdirectory > of the PG installation. > > regards, tom lane I found it; there was a permission problem during the install and Postgres' startup, when reading those files, apparently didn't complain about it -- it just didn't load them all (but did load others!) and that resulted in an inconsistency that made things very angry..... :-) Sorry about the false alarm.... --=20 Karl Denninger karl@denninger.net /The Market Ticker/ /[S/MIME encrypted email preferred]/ --------------DC5D1CBC79031C64C52651B8 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 3/2/2018 10:58, Tom Lane wrote:
Karl Denninger <karl@denninger.net> writes:
I have just tried r0lling forward to 10.3 from 10.=
1 and suddenly my time
zone declaration blew up.

      
I was using 'US/Chicago' and was able to get the s=
erver to start with
CST6CDT, which is the way the system is set up.=C2=A0 But I'm concerned a=
bout
this, because I now get this from trying to query the system tables for
timezone names:

      
pgsql=3D# select * from pg_timezone_names;
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | abbrev | utc_offset=
 | is_dst
--------------------------+--------+------------+--------
=C2=A0Canada/East-Saskatchewan | CST=C2=A0=C2=A0=C2=A0 | -06:00:00=C2=A0 =
| f
(1 row)

      
pgsql=3D# select * from pg_timezone_abbrevs;
ERROR:=C2=A0 time zone "Asia/Yerevan" not recognized
DETAIL:=C2=A0 This time zone name appears in the configuration file for t=
ime
zone abbreviation "amst".
Hmm, is your build configured with --with-system-tzdata
(pg_config --configure would tell you)?  If so, is that pointing at
a reasonable-looking tree of TZ data?  It seems you don't have the
TZ data correctly installed in the 10.3 installation, but it's hard
to tell who to blame from this much info.

Typically the top of the TZ file tree should look like

$ ls /usr/share/zoneinfo
Africa/      Canada/  GB         Indian/    Mexico/   ROK        iso3166.=
tab
America/     Chile/   GB-Eire    Iran       NZ        Singapore  leapseco=
nds
Antarctica/  Cuba     GMT        Israel     NZ-CHAT   Turkey     posix/
Arctic/      EET      GMT+0      Jamaica    Navajo    UCT        posixrul=
es
Asia/        EST      GMT-0      Japan      PRC       US/        right/
Atlantic/    EST5EDT  GMT0       Kwajalein  PST8PDT   UTC        tzdata.z=
i
Australia/   Egypt    Greenwich  Libya      Pacific/  Universal  zone.tab=

Brazil/      Eire     HST        MET        Poland    W-SU       zone1970=
=2Etab
CET          Etc/     Hongkong   MST        Portugal  WET
CST6CDT      Europe/  Iceland    MST7MDT    ROC       Zulu

If you're not trying to rely on a platform-provided installation
of tzdata, then this ought to be under the share/ subdirectory
of the PG installation.

			regards, tom lane
I found it; there was a permission problem during the install and Postgres' startup, when reading those files, apparently didn't complain about it -- it just didn't load them all (but did load others!) and that resulted in an inconsistency that made things very angry..... :-)

Sorry about the false alarm....

--
Karl Denninger
karl@denninger.net
The Market Ticker
[S/MIME encrypted email preferred]
--------------DC5D1CBC79031C64C52651B8-- --------------ms000700060003000301070709 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExDzANBglghkgBZQMEAgMFADCABgkqhkiG9w0BBwEAAKCC DdgwggagMIIEiKADAgECAhMA5EiKghDOXrvfxYxjITXYDdhIMA0GCSqGSIb3DQEBCwUAMIGL MQswCQYDVQQGEwJVUzEQMA4GA1UECAwHRmxvcmlkYTESMBAGA1UEBwwJTmljZXZpbGxlMRkw FwYDVQQKDBBDdWRhIFN5c3RlbXMgTExDMRgwFgYDVQQLDA9DdWRhIFN5c3RlbXMgQ0ExITAf BgNVBAMMGEN1ZGEgU3lzdGVtcyBMTEMgMjAxNyBDQTAeFw0xNzA4MTcxNjQyMTdaFw0yNzA4 MTUxNjQyMTdaMHsxCzAJBgNVBAYTAlVTMRAwDgYDVQQIDAdGbG9yaWRhMRkwFwYDVQQKDBBD dWRhIFN5c3RlbXMgTExDMRgwFgYDVQQLDA9DdWRhIFN5c3RlbXMgQ0ExJTAjBgNVBAMMHEN1 ZGEgU3lzdGVtcyBMTEMgMjAxNyBJbnQgQ0EwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIK AoICAQC1aJotNUI+W4jP7xQDO8L/b4XiF4Rss9O0B+3vMH7Njk85fZ052QhZpMVlpaaO+sCI KqG3oNEbuOHzJB/NDJFnqh7ijBwhdWutdsq23Ux6TvxgakyMPpT6TRNEJzcBVQA0kpby1DVD 0EKSK/FrWWBiFmSxg7qUfmIq/mMzgE6epHktyRM3OGq3dbRdOUgfumWrqHXOrdJz06xE9NzY vc9toqZnd79FUtE/nSZVm1VS3Grq7RKV65onvX3QOW4W1ldEHwggaZxgWGNiR/D4eosAGFxn uYeWlKEC70c99Mp1giWux+7ur6hc2E+AaTGh+fGeijO5q40OGd+dNMgK8Es0nDRw81lRcl24 SWUEky9y8DArgIFlRd6d3ZYwgc1DMTWkTavx3ZpASp5TWih6yI8ACwboTvlUYeooMsPtNa9E 6UQ1nt7VEi5syjxnDltbEFoLYcXBcqhRhFETJe9CdenItAHAtOya3w5+fmC2j/xJz29og1KH YqWHlo3Kswi9G77an+zh6nWkMuHs+03DU8DaOEWzZEav3lVD4u76bKRDTbhh0bMAk4eXriGL h4MUoX3Imfcr6JoyheVrAdHDL/BixbMH1UUspeRuqQMQ5b2T6pabXP0oOB4FqldWiDgJBGRd zWLgCYG8wPGJGYgHibl5rFiI5Ix3FQncipc6SdUzOQIDAQABo4IBCjCCAQYwHQYDVR0OBBYE FF3AXsKnjdPND5+bxVECGKtc047PMIHABgNVHSMEgbgwgbWAFBu1oRhUMNEzjODolDka5k4Q EDBioYGRpIGOMIGLMQswCQYDVQQGEwJVUzEQMA4GA1UECAwHRmxvcmlkYTESMBAGA1UEBwwJ TmljZXZpbGxlMRkwFwYDVQQKDBBDdWRhIFN5c3RlbXMgTExDMRgwFgYDVQQLDA9DdWRhIFN5 c3RlbXMgQ0ExITAfBgNVBAMMGEN1ZGEgU3lzdGVtcyBMTEMgMjAxNyBDQYIJAKxAy1WBo2kY MBIGA1UdEwEB/wQIMAYBAf8CAQAwDgYDVR0PAQH/BAQDAgGGMA0GCSqGSIb3DQEBCwUAA4IC AQCB5686UCBVIT52jO3sz9pKuhxuC2npi8ZvoBwt/IH9piPA15/CGF1XeXUdu2qmhOjHkVLN gO7XB1G8CuluxofOIUce0aZGyB+vZ1ylHXlMeB0R82f5dz3/T7RQso55Y2Vog2Zb7PYTC5B9 oNy3ylsnNLzanYlcW3AAfzZcbxYuAdnuq0Im3EpGm8DoItUcf1pDezugKm/yKtNtY6sDyENj tExZ377cYA3IdIwqn1Mh4OAT/Rmh8au2rZAo0+bMYBy9C11Ex0hQ8zWcvPZBDn4v4RtO8g+K uQZQcJnO09LJNtw94W3d2mj4a7XrsKMnZKvm6W9BJIQ4Nmht4wXAtPQ1xA+QpxPTmsGAU0Cv HmqVC7XC3qxFhaOrD2dsvOAK6Sn3MEpH/YrfYCX7a7cz5zW3DsJQ6o3pYfnnQz+hnwLlz4MK 17NIA0WOdAF9IbtQqarf44+PEyUbKtz1r0KGeGLs+VGdd2FLA0e7yuzxJDYcaBTVwqaHhU2/ Fna/jGU7BhrKHtJbb/XlLeFJ24yvuiYKpYWQSSyZu1R/gvZjHeGb344jGBsZdCDrdxtQQcVA 6OxsMAPSUPMrlg9LWELEEYnVulQJerWxpUecGH92O06wwmPgykkz//UmmgjVSh7ErNvL0lUY UMfunYVO/O5hwhW+P4gviCXzBFeTtDZH259O7TCCBzAwggUYoAMCAQICEwCg0WvVwekjGFiO 62SckFwepz0wDQYJKoZIhvcNAQELBQAwezELMAkGA1UEBhMCVVMxEDAOBgNVBAgMB0Zsb3Jp ZGExGTAXBgNVBAoMEEN1ZGEgU3lzdGVtcyBMTEMxGDAWBgNVBAsMD0N1ZGEgU3lzdGVtcyBD QTElMCMGA1UEAwwcQ3VkYSBTeXN0ZW1zIExMQyAyMDE3IEludCBDQTAeFw0xNzA4MTcyMTIx MjBaFw0yMjA4MTYyMTIxMjBaMFcxCzAJBgNVBAYTAlVTMRAwDgYDVQQIDAdGbG9yaWRhMRkw FwYDVQQKDBBDdWRhIFN5c3RlbXMgTExDMRswGQYDVQQDDBJrYXJsQGRlbm5pbmdlci5uZXQw ggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC+HVSyxVtJhy3Ohs+PAGRuO//Dha9A 16l5FPATr6wude9zjX5f2lrkRyU8vhCXTZW7WbvWZKpcZ8r0dtZmiK9uF58Ec6hhvfkxJzbg 96WHBw5Fumd5ahZzuCJDtCAWW8R7/KN+zwzQf1+B3MVLmbaXAFBuKzySKhKMcHbK3/wjUYTg y+3UK6v2SBrowvkUBC+jxNg3Wy12GsTXcUS/8FYIXgVVPgfZZrbJJb5HWOQpvvhILpPCD3xs YJFNKEPltXKWHT7Qtc2HNqikgNwj8oqOb+PeZGMiWapsatKm8mxuOOGOEBhAoTVTwUHlMNTg 6QUCJtuWFCK38qOCyk9Haj+86lUU8RG6FkRXWgMbNQm1mWREQhw3axgGLSntjjnznJr5vsvX SYR6c+XKLd5KQZcS6LL8FHYNjqVKHBYM+hDnrTZMqa20JLAF1YagutDiMRURU23iWS7bA9tM cXcqkclTSDtFtxahRifXRI7Epq2GSKuEXe/1Tfb5CE8QsbCpGsfSwv2tZ/SpqVG08MdRiXxN 5tmZiQWo15IyWoeKOXl/hKxA9KPuDHngXX022b1ly+5ZOZbxBAZZMod4y4b4FiRUhRI97r9l CxsP/EPHuuTIZ82BYhrhbtab8HuRo2ofne2TfAWY2BlA7ExM8XShMd9bRPZrNTokPQPUCWCg CdIATQIDAQABo4IBzzCCAcswPAYIKwYBBQUHAQEEMDAuMCwGCCsGAQUFBzABhiBodHRwOi8v b2NzcC5jdWRhc3lzdGVtcy5uZXQ6ODg4ODAJBgNVHRMEAjAAMBEGCWCGSAGG+EIBAQQEAwIF oDAOBgNVHQ8BAf8EBAMCBeAwHQYDVR0lBBYwFAYIKwYBBQUHAwIGCCsGAQUFBwMEMDMGCWCG SAGG+EIBDQQmFiRPcGVuU1NMIEdlbmVyYXRlZCBDbGllbnQgQ2VydGlmaWNhdGUwHQYDVR0O BBYEFLElmNWeVgsBPe7O8NiBzjvjYnpRMIHKBgNVHSMEgcIwgb+AFF3AXsKnjdPND5+bxVEC GKtc047PoYGRpIGOMIGLMQswCQYDVQQGEwJVUzEQMA4GA1UECAwHRmxvcmlkYTESMBAGA1UE BwwJTmljZXZpbGxlMRkwFwYDVQQKDBBDdWRhIFN5c3RlbXMgTExDMRgwFgYDVQQLDA9DdWRh IFN5c3RlbXMgQ0ExITAfBgNVBAMMGEN1ZGEgU3lzdGVtcyBMTEMgMjAxNyBDQYITAORIioIQ zl6738WMYyE12A3YSDAdBgNVHREEFjAUgRJrYXJsQGRlbm5pbmdlci5uZXQwDQYJKoZIhvcN AQELBQADggIBAJXboPFBMLMtaiUt4KEtJCXlHO/3ZzIUIw/eobWFMdhe7M4+0u3te0sr77QR dcPKR0UeHffvpth2Mb3h28WfN0FmJmLwJk+pOx4u6uO3O0E1jNXoKh8fVcL4KU79oEQyYkbu 2HwbXBU9HbldPOOZDnPLi0whi/sbFHdyd4/w/NmnPgzAsQNZ2BYT9uBNr+jZw4SsluQzXG1X lFL/qCBoi1N2mqKPIepfGYF6drbr1RnXEJJsuD+NILLooTNf7PMgHPZ4VSWQXLNeFfygoOOK FiO0qfxPKpDMA+FHa8yNjAJZAgdJX5Mm1kbqipvb+r/H1UAmrzGMbhmf1gConsT5f8KU4n3Q IM2sOpTQe7BoVKlQM/fpQi6aBzu67M1iF1WtODpa5QUPvj1etaK+R3eYBzi4DIbCIWst8MdA 1+fEeKJFvMEZQONpkCwrJ+tJEuGQmjoQZgK1HeloepF0WDcviiho5FlgtAij+iBPtwMuuLiL shAXA5afMX1hYM4l11JXntle12EQFP1r6wOUkpOdxceCcMVDEJBBCHW2ZmdEaXgAm1VU+fnQ qS/wNw/S0X3RJT1qjr5uVlp2Y0auG/eG0jy6TT0KzTJeR9tLSDXprYkN2l/Qf7/nT6Q03qyE QnnKiBXWAZXveafyU/zYa7t3PTWFQGgWoC4w6XqgPo4KV44OMYIFBzCCBQMCAQEwgZIwezEL MAkGA1UEBhMCVVMxEDAOBgNVBAgMB0Zsb3JpZGExGTAXBgNVBAoMEEN1ZGEgU3lzdGVtcyBM TEMxGDAWBgNVBAsMD0N1ZGEgU3lzdGVtcyBDQTElMCMGA1UEAwwcQ3VkYSBTeXN0ZW1zIExM QyAyMDE3IEludCBDQQITAKDRa9XB6SMYWI7rZJyQXB6nPTANBglghkgBZQMEAgMFAKCCAkUw GAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTgwMzAyMTcwMTAx WjBPBgkqhkiG9w0BCQQxQgRAeJNbk846WT013zcsUzK/u+s4EL7v0LZrEIAcWqj4aubHOVBE XNzw8Ei5EeXC7PkrwaiwuNLqAIKH2e+uiVwhMzBsBgkqhkiG9w0BCQ8xXzBdMAsGCWCGSAFl AwQBKjALBglghkgBZQMEAQIwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCAMA0GCCqGSIb3 DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMIGjBgkrBgEEAYI3EAQxgZUwgZIwezEL MAkGA1UEBhMCVVMxEDAOBgNVBAgMB0Zsb3JpZGExGTAXBgNVBAoMEEN1ZGEgU3lzdGVtcyBM TEMxGDAWBgNVBAsMD0N1ZGEgU3lzdGVtcyBDQTElMCMGA1UEAwwcQ3VkYSBTeXN0ZW1zIExM QyAyMDE3IEludCBDQQITAKDRa9XB6SMYWI7rZJyQXB6nPTCBpQYLKoZIhvcNAQkQAgsxgZWg gZIwezELMAkGA1UEBhMCVVMxEDAOBgNVBAgMB0Zsb3JpZGExGTAXBgNVBAoMEEN1ZGEgU3lz dGVtcyBMTEMxGDAWBgNVBAsMD0N1ZGEgU3lzdGVtcyBDQTElMCMGA1UEAwwcQ3VkYSBTeXN0 ZW1zIExMQyAyMDE3IEludCBDQQITAKDRa9XB6SMYWI7rZJyQXB6nPTANBgkqhkiG9w0BAQEF AASCAgBxwlAjUKI1/+ZsvTtPabP760RNy2QQm+NvLS//1C0u/bNa62d04hMATTCh9ZV8qVzF lVIxobT7hS4uoc8tWi5r9cVRlJl74VVL6TQIXZfLEGn8qyBwf4mvq8QkJ2JAwVnmEmzVAVoq Pto+h5zwpfArE9+elcUEtXssRNV3wOQIslzXFZvrv+WWkkWM/FCw/VAXRt8VAcfhIKzNidsL Rbyq5rO4qm1ty33uihTDG4TY/pCeqB905HeMTgG7lbBabFFgBpJdNPyFNWq81g+WWMG2X5T1 f6z/iUYRVyQDXS18JJGDqSc93G6Ju/4S4z/LtTl9oH/EFsfAjtPmvfb/5axpT7REG64yKRyd ++p9P59rK5bBIqebMZ1jYHXnwDZjNcmwiRna0uSd3Xw6yTlVN/6DeicNB6TC7WD2FjrgG3Og YvV4iRUT5WB9bfROEt0kxdnupy8G/P+PltWZDlrntlH6SECm0/c9xLRcgquI6r8Cbbkf6n9x MF7uH6qlncD0m2g2baW9Y2VA0qiEKNTe9aY6cJKJ167cxG5wLVoU3BJX9vGO3P8Xw+/rZARC oTSSN2v1kIzUPAoFla6m8HlVFjvoJIsWQOuqUBvqGTWkz1s5KW8Bxu0KemnPalmBn7zluQLd F2IoPgC/yrLigymt/4u9qEJQqgIwnTOBrDkZ7F3piQAAAAAAAA== --------------ms000700060003000301070709--