Amski

Hey, Have been running into issues recently with PostgresSQL containers not starting anymore with the following errors: LOG: invalid value for parameter "log_timezone": "Europe/Kiev" LOG: invalid value for parameter "TimeZone": "Europe/Kiev" FATAL: configuration file "/var/lib/postgresql/data/postgresql.conf" contains errorsLooking into the issue I found that Unraid sets the timezone to "Europe/Kiev" when the time zone in Unraid Date and Time settings is set to (UTC+02.00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius. Since Unraid sets the TZ variable for all Docker containers automatically, the PostgreSQL container picks that up and set it as the timezone in postgresql.conf. Looked into it some more and turns out that ICANN has changed the timezone format from Europe/Kiev to Europe/Kyiv in 2022. I guess something has recently changed in the PostgreSQL 16 container image which has caused Europe/Kiev to not be a valid anymore and that's causing the container to not start. Changing the "TimeZone" and "log_timezone" parameters in postgresql.conf to Europe/Kyiv fixes the issue. It seems that the main issue is that Unraid is in need of a time zone data update since Europe/Kyiv doesn't even exist in /usr/share/zoneinfo/ Weirdly enough the only recent mention for time zone data in PostgreSQL release notes is in version 16.9 and Kiev/Kyiv is not mentioned there at all. Tzdata has changed to the new format back in 2022. Not really sure what changed and where but the containers not running because of the time zone issue is a new one. PostgreSQL has been running perfectly fine for multiple years before with the same time zone setting.