Debian 13, Postgres, and the US/* time zones
Background: Debian 13 and tzdata-legacy
- Debian 13 moved many long-deprecated time zone names (including
US/*) into a separatetzdata-legacypackage, so they’re no longer installed by default. - These aliases have been officially “backward-compatibility” names in the IANA tzdb since the early 1990s, maintained via the
backwardfile. - The change affects software still using
US/*zones (e.g., Postgres configs, Interactive Brokers TWS, some libraries), which now fail untiltzdata-legacyis installed or configs are updated.
Why legacy US/* zones are still used
- Inertia and muscle memory: old configs get copied forward for decades with little scrutiny.
- Tutorials, examples, and historical defaults reinforced
US/*usage. - Some find
US/Easternor “US Pacific” more intuitive and aligned with colloquial/official names thanAmerica/New_York. - Typing convenience (
US/EasternvsAmerica/New_York) may also play a role.
Time zone naming philosophy and politics
- tzdb explicitly avoids country-based IDs to sidestep border disputes and maintain historical stability; preferred format is continent/ocean + representative city.
- Country-based names (e.g.,
US/*,Poland) are kept only as backward-compatibility aliases. - City-based IDs also avoid fights over contested places (e.g.,
Asia/Jerusaleminstead of country-prefixed). - Some argue country-based names better reflect that time is defined politically; others counter that countries change more than cities.
Debian behavior and communication
- Some see Debian’s move as overdue alignment with upstream; others call it a “monstrously stupid” breaking change given how pervasive tzdata is.
- Frustration that such a widely impactful change wasn’t in Debian 13 release notes; maintainers point to per-package
NEWS.Debianand tools likeapt-listchanges. - Broader complaints: Debian’s habit of downstream patching (e.g., OpenSSH, nginx defaults) and the difficulty of tracking those changes.
Operational lessons: UTC, configs, and future times
- Many advocate running servers in
Etc/UTCand storing timestamps in UTC to avoid a class of bugs, with conversion at the edges. - Others note UTC alone is insufficient for future events defined in local civil time (DST and law changes).
- The thread highlights the need to regularly review configs on upgrades (not just copy old files) and to treat time zones as a moving, political target rather than a stable constant.