Debian 13 Upgrade Issue: PostgreSQL Time Zone Configuration Errors with US/Pacific Setting
By
move-on-by
Toasted just enough. A reliable bake, gently seasoned.
Summary
The article describes a technical issue encountered when upgrading from Debian 12 to Debian 13 with PostgreSQL databases, specifically related to time zone configuration. The author experienced errors with US/Pacific timezone settings that caused PostgreSQL to fail to start, requiring manual intervention to comment out the problematic configuration lines to get the database running again.
Key quotes
· 4 pulled2025-08-29 06:28:12.038 GMT [220328] LOG: invalid value for parameter "log_timezone": "US/Pacific"
2025-08-29 06:28:12.038 GMT [220328] LOG: invalid value for parameter "TimeZone": "US/Pacific"
2025-08-29 06:28:12.038 GMT [220328] FATAL: configuration file "/etc/postgresql/15/main/postgresql.conf" contains errors
At the time, I went "WTF?" and just commented it out to get it running again
You might also wanna read
PostgreSQL Transaction ID Wraparound Incident: A Production Database Outage Case Study
This article details a real-world PostgreSQL production incident caused by transaction ID wraparound, a critical database failure mode. The
sqlservercentral.com·1mo ago
PostgreSQL work_mem Configuration Pitfalls: How Low Memory Settings Can Cause Catastrophic Outages
The article discusses a critical PostgreSQL database performance issue where a production cluster with 2 TB of RAM was killed by the OOM (Ou
mydbanotebook.org·2mo ago
Bootc and OSTree: Modern Approaches to Linux System Deployment and Configuration Management
The article explores using Bootc and OSTree as modern solutions for Linux system deployment, focusing on achieving reproducible, consistent
a-cup-of.coffee·3mo ago
systemd v259 Announces Deprecation of System V Service Scripts, Removal Planned for v260
systemd v259 announces the deprecation and upcoming removal of System V service script support in v260, requiring users to migrate to native
github.com·5mo ago
Technical Analysis and Critique of D-Bus Implementation in Linux Systems
The article is a technical critique of D-Bus, a message bus system used in Linux desktop environments. The author acknowledges D-Bus's usefu
blog.vaxry.net·5mo ago
PostgreSQL VACUUM Limitations: Why Indexes Become Bloated and How to Fix Them
This article debunks common misconceptions about PostgreSQL's VACUUM command, explaining that while VACUUM cleans dead tuples from tables, i
boringsql.com·5mo ago