Search Postgresql Archives

Re: here does postgres take its timezone information from?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux