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(dot)klaver(at)aklaver(dot)com