Re: here does postgres take its timezone information from?

On 11/5/19 3:00 PM, Chris Withers wrote:
> On 05/11/2019 22:54, Adrian Klaver wrote:
>> On 11/5/19 2:46 PM, Chris Withers wrote:
>>> Hi All,
>>>
>>> Brazil recently abolished daylight savings time, resulting in updates 
>>> to system timezone information packages.
>>> Does postgres use these? If so, does it need a reload or restart to 
>>> see the updated zone info?
>>>
>>> If not, how does postgres store/obtain its timezone zone information 
>>> and how would this be updated?
>>
>> https://www.postgresql.org/about/news/1960/
>> PostgreSQL 11.5, 10.10, 9.6.15, 9.5.19, 9.4.24, and 12 Beta 3 Released!
>>
>> "This update also contains tzdata release 2019b for DST law changes in 
>> Brazil, plus historical corrections for Hong Kong, Italy, and 
>> Palestine. This update also adds support for zic's new -b slim option 
>> to reduce the size of the installed zone files, though it is not 
>> currently being used by PostgreSQL."
> 
> Hmm. Is there any option to use the system timezone packages?


https://www.postgresql.org/docs/11/install-procedure.html

--with-system-tzdata=DIRECTORY

> 
> If not, why not?
> 
> Chris


-- 
Adrian Klaver
adrian.klaver@aklaver.com